Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PivotChart & Secondary Axes
Is it possible to have a pivotchart with a primary & secondary axes in Excel
2002? If so, how do you setup the secondary axes? Thanks |
#2
|
|||
|
|||
Right-click on the series you want to change, and select 'Format Data
Series' On the Axis tab, select Secondary Axis, click. However, loss of formatting is a known problem with pivot charts, so you may want to record a macro as you change the axis. There's information in the following MSKB article: Changing a PivotChart Removes Series Formatting in Excel http://support.microsoft.com/?id=215904 controlsrfun wrote: Is it possible to have a pivotchart with a primary & secondary axes in Excel 2002? If so, how do you setup the secondary axes? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
When I try this, the choice for changing to a secondary axis is greyed out
and not selectable. I know how to make a secondary axis for a regular chart but it seems as if it can not be applied to a pivot chart? "Debra Dalgleish" wrote: Right-click on the series you want to change, and select 'Format Data Series' On the Axis tab, select Secondary Axis, click. However, loss of formatting is a known problem with pivot charts, so you may want to record a macro as you change the axis. There's information in the following MSKB article: Changing a PivotChart Removes Series Formatting in Excel http://support.microsoft.com/?id=215904 controlsrfun wrote: Is it possible to have a pivotchart with a primary & secondary axes in Excel 2002? If so, how do you setup the secondary axes? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I change background colors between secondary y axis lines? | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
secondary axis scale | Charts and Charting in Excel | |||
Secondary Axis? | Charts and Charting in Excel |