Setting up a spread sheet so that it yields graph I want.

  • Thread starter Thread starter Dot
  • Start date Start date
D

Dot

I want to list the names of 5 birds, the date I took its
weight, and the weight of the bird. How do I set up the
spreadsheet so that I can make one graph that has five
lines, one for each bird, and plots their weight
according to date?

Dot
 
Create one table with the name in one column, the date in the 2nd
column, and the weight in the 3rd column. Then, create a PivotTable
(and PivotChart). Put the Name as the column field, the date as the
row field, and the weight as the data field. Change the type of the
PivotChart from the default Column to Line.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks. Do I put all the names in one table? Name in
A1, Date in B1, Weight in C1, then another name in D1,
Date in E1, Weight in F1? I tried to create a PivotTable
but it didn't work right. Should I have selected
PivotChart?
Dot
 
Also, when I drop something into the appropriate place,
it gives me a sum of the weights. I want to show each
weight.
Dot
 
Use only three columns. Something like:

BirdName Date Weight
Bird1 1/1/04 10
Bird2 1/1/04 12
Bird3 1/1/04 13
Bird1 2/1/04 12
Bird2 2/1/04 12
Bird3 2/1/04 15
Bird4 2/1/04 10
Bird1 3/1/04 14
....

The PivotTable will Sum the data, but that is just OK because you will
have a single entry for each combination of bird and date. And, the
sum of a single number is the single number itself! <g>

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top