| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Preserving PivotChart Formatting
I created a PivotChart and modified the colors for the chart bars. Whenever
I pivot the chart to create different views of the PivotChart, my custom colors for the chart bars revert back to the default colors. Is there a way that I can preserve the formatting attributes of my PivotCharts regardless of how many different views I create? By the way, the same data source is being used to create different views. Thanks in advanced. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Preserving PivotChart Formatting
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, which suggests recording a macro as you apply the formatting: Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/?id=215904 Outlook Convert wrote: I created a PivotChart and modified the colors for the chart bars. Whenever I pivot the chart to create different views of the PivotChart, my custom colors for the chart bars revert back to the default colors. Is there a way that I can preserve the formatting attributes of my PivotCharts regardless of how many different views I create? By the way, the same data source is being used to create different views. Thanks in advanced. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Preserving PivotChart Formatting
Thanks Debra!
"Debra Dalgleish" wrote: Loss of formatting is a known problem with pivot charts. There's information in the following MSKB article, which suggests recording a macro as you apply the formatting: Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/?id=215904 Outlook Convert wrote: I created a PivotChart and modified the colors for the chart bars. Whenever I pivot the chart to create different views of the PivotChart, my custom colors for the chart bars revert back to the default colors. Is there a way that I can preserve the formatting attributes of my PivotCharts regardless of how many different views I create? By the way, the same data source is being used to create different views. Thanks in advanced. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make pivotchart formatting stick after pivottable refresh. | Charts and Charting in Excel | |||
| Preserving cell formatting when protecting or unrprotecting | Excel Discussion (Misc queries) | |||
| Preserving formatting in a formula. | Excel Discussion (Misc queries) | |||
| MS Query from Excel - Preserving formatting, validation and Commen | Excel Discussion (Misc queries) | |||
| Preserving Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
