How I can switch row/column in pivot chart?

K

kesentu

Hi,
I have the new office 2007, in excel I try to draw pivot chart, I succeded.
But I want to switch row into column and column into row. When I try to do
that tis button bocomes invisible while I can do in PPT.
Please help me!!

Regards,

Tuba Kesen Umar
 
J

Jon Peltier

Pivot charts in Excel 2000 through 2007 only allow you to plot series in
columns. However, you could rebuild the pivot table so that your old column
fields are located in the rows area and vice versa.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot chart - switch axis 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Arrange columns (lo - hi) in a Pivot Chart bar graph. 2
Pivot chart and Total row 0
How to include the Grand Total Column in a pivot table chart? 1
Using VBA to create charts 1
How do i export a pivot chart as a static chart object? 2
How to stop pivot table crashing in Excel 2007 0

Top