Pivot Table Chart

[el_grimley]

Morning

I have a Pivot Table with "Year&Month" as my columns, "Product" as m
rows and data within the table is "Total Sales". When I use the aut
chart function I get "Total Sales" as my X Axis, "Product" as my Y an
then "Year&Month" as my data series. However what I really want is fo
"Product" to be the data series and "Year&Month" to be my Y. If I mov
the chart options to look like this it changes the pivot tabl
accordingly but as I have more than 256 products this causes excel t
have a hissy fit.

Is there any where in the options where I can change how I want th
data to be laid out within the chart, without affecting the pivo
table?

Thanks

Graha

 

[topola]

Tried your case in a simple workbook. Switching ITEM and YEARS in
Pivot Rows and Columns produces changes to the chart. This is a simple
move in a Pivot Table Layout. However YEARS become X and not Y as you
mention. Try how it works for you.

 

[el_grimley]

Thanks for your reply topola but I really wanted to keep the pivot table
as is and only change the chart.

thanks

Graham

 

[topola]

Unlike in a normal chart Source Data is not highlighted. I don't know
how to change it. topola

 

[el_grimley]

Just thought I'd mention this before someone suggests it.

I've had another look through the excel help and I've come accross the
idea to use a staic table from copied and pasted values from the pivot
tabel. This however does not produce enough detail in the axis of the
graph.

Any one, any Ideas?

graham