Pivot Chart, line graph w/ multiple series

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

In article ,
says...
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?

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.


-----Original Message-----
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

In article ,
says...
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?

.

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

bob wrote:

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.



-----Original Message-----
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

In article ,
says...

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 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

In article ,
says...
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.


-----Original Message-----
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

In article ,
says...
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?

.