| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keep format after pivot
Is there a way to maintain a chart's format after you change the data
you are looking at? I build a pivot chart and whenever I pivot to view different data, the chart type reverts from a line -2 axis (which I selected) back to a bar graph. Thanks in advance CG |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Keep format after pivot
This is a known bug that required vba code to re-apply formatting.
XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy CG wrote: Is there a way to maintain a chart's format after you change the data you are looking at? I build a pivot chart and whenever I pivot to view different data, the chart type reverts from a line -2 axis (which I selected) back to a bar graph. Thanks in advance CG -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table: how to programmatically format headers? | Excel Discussion (Misc queries) | |||
| pivot table format report - setting default | Excel Discussion (Misc queries) | |||
| How do you turn off pivot table auto format in Excel? | Excel Discussion (Misc queries) | |||
| format changes on pivot table although preserve formatting is che. | Excel Discussion (Misc queries) | |||
| How Do You Permanently Format Fields of a Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
