Charts based on Pivot Tables

[el_grimley]

Morning

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

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

Thanks

Graham

 

[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

 

[Jon Peltier]

The pivot table and pivot chart are intimately linked, and both share the same pivot layout. If you want a chart that looks different than the pivot table, make a chart based on a different pivot table.