Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.charting
|
|||
|
|||
Pivot chart
I am working with Excel 2007 trying to create a chart. When creating the
line chart within a pivot table, the pivot chart is putting the data that needs to be in the horizontal axis in the legend series. I would like it to be switched. The button to switch these items is grayed out. Why is that? If I just created the data in the Excel spreadsheet (not using a pivot table), it is not grayed out. thanks, Will |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Pivot chart
Hi,
Because this is the way Microsoft programmed it. The way to switch fields on the pivot chart is to move the fields in the pivot table. When the pivot chart is selected the Pivot Table Field List shows the Ledgend Fields (Series) where the Column Labels are normally displayed and the Axis Fields (Categories) where the Row Labels usually are. This is where you swap fields. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Will Fleenor" wrote: I am working with Excel 2007 trying to create a chart. When creating the line chart within a pivot table, the pivot chart is putting the data that needs to be in the horizontal axis in the legend series. I would like it to be switched. The button to switch these items is grayed out. Why is that? If I just created the data in the Excel spreadsheet (not using a pivot table), it is not grayed out. thanks, Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Maintain colour changes in a Pivot Chart when changing Pivot value | Charts and Charting in Excel | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |