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