Hi all

In Excel 2007, I have a Pivot table that consists of
Rows = Manufacturers name
Columns = Annual figures (2001, 2002, 2003 etc...)
At the end of the columns is a Grand total, and the chart is sorted on highest to lowest.

I want to create a line chart from this, with the Manufacturers names in the Vertical Axis, and the years in the Horizontal axis, so that this shows the annual fluctuation in totals.

However, Excel creates this the other way round, and the option to swap them on the Data selection tool is of course greyed out.

How do I get around this please?

Thanks
Neil