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. |
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. |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com