Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart - switch axis
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart - switch axis
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 "JICDB" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to switch the primary and secondary Y axis to opposite chart s | Charts and Charting in Excel | |||
How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
Excel 2003 Line Chart - Switch Axis Position | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I switch the axis values in my chart | Charts and Charting in Excel |