Pivot Chart, line graph w/ multiple series

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have columns of cust, year, est sales, actual sales.
Customer is put in page area, year is put on category
axis. I can add est sales to data area and will have one
line. But when I add the actual sales to the data area,
it does not show as a line, but adds itself to the
category x axis. Am I missing something?
 
If you are adding the field directly on to the PivotChart, consider
using the associated PivotTable. Is the 'actual sales' column part of
the data field or one of the the row/column fields? Ensure it is a
data field.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
thanks for the help, but I am not sure what you mean
by "data field" vs row/column fields. I have 4 columns in
my spreadsheet: cust, year, est sales, actual sales. I
would think I could create a pivot chart line graph
containing two lines, est sales and actual sales.
 
Bob -

The data area is where you put the fields that are to be totaled,
averaged, or otherwise processed by the pivot table, according to the
fields which are in the row area and column area. I just have Excel 97
here at work, so I can't tell you how to do this on your chart, but in
the pivot table itself, the data area is the big region below the column
fields and to the right of the row fields.

- Jon
 
If you are using XL2002 (I can't comment on earlier versions), in an
empty PivotTable there will be regions marked in light gray 'Drop row
fields here' 'Drop column fields here' and 'Drop data items here'

--
Regards,

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