| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keep Pivot Table Chart Format unchanged
I want to keep changes to format i performed in a pivot chart, that would not
be affected upon refresh table. thanks\ |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Keep Pivot Table Chart Format unchanged
This is a known bug that requires vba code to re-apply formatting.
XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy Nir wrote: I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\ -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Keep Pivot Table Chart Format unchanged
thanks Andy,
does MS supply any add-in for or just record it on my local report? thanks "Andy Pope" wrote: This is a known bug that requires vba code to re-apply formatting. XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy Nir wrote: I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\ -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Keep Pivot Table Chart Format unchanged
Use the macro recorder to capture the formatting commands.
Here is a great resource for all things pivot tablely! http://www.contextures.com/xlfaqPivot.html Cheers Andy Nir wrote: thanks Andy, does MS supply any add-in for or just record it on my local report? thanks "Andy Pope" wrote: This is a known bug that requires vba code to re-apply formatting. XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy Nir wrote: I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\ -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Chart | Excel Discussion (Misc queries) | |||
| Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
| pie-charting non-numeric data | Charts and Charting in Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
