Pivot chart - switch axis

[JICDB]

My boss likes to see dates going across - whether its on the top of a table
or the bottom of a chart. I have a pivot table with the dates across the top
and the bus routes across the left side (I work for the public transportation
company) with the sum of riders for that date and route number in the middle.
The table is perfect, the graph shows the routes along the bottom with the
dates in the bar. I want to flip these so that the dates go along the bottom
and trends can be seen more easily. In a regular chart I can do that by
changing rows/columns from the Chart Data section but in a pivot chart I
don't see this option. Do I have to create a different pivot table with the
dates along the side and the routes across the top to get the graph the way I
want? Thanks for your help.

 

[Shane Devenshire]

Hi,

On the PivotChart try dragging the Date field down to the bottom center of
the chart where you see field buttons. Then drag the route button to the
top left corner area of the pivot chart. If this does what you want, check
out the pivot table to see how the fields are now arranges so in the future
you can put them in the necessary locations without having to do it on the
chart.

Cheers,
Shane Devenshire