Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Reset the colors in a chart
I have a series of pivot table charts--one for all employees, and individual
ones. I want to give the projects the same color legend across all the charts. I've tried changing the legends, one-by-one, then saving the chart, then moving to the next iteration, but when I go back to the first chart, the colors have returned to the defaults. What am I missing? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Reset the colors in a chart
Pivot Charts reset their formatting at the merest hint of refreshing the
pivot data. You would need to record a macro while fixing the chart, then rerun the macro every time you refresh the pivot table. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JanHDon" wrote in message ... I have a series of pivot table charts--one for all employees, and individual ones. I want to give the projects the same color legend across all the charts. I've tried changing the legends, one-by-one, then saving the chart, then moving to the next iteration, but when I go back to the first chart, the colors have returned to the defaults. What am I missing? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Reset the colors in a chart
You could customize the automatic colours as used by default in charts.
Tools, Options, Colors look at colours starting in the 6th row and compare with default (non formatted) colours in your pivot charts After customizing the palette to your needs hopefully you won't need to apply your own colour formats. Keep in mind the palette belongs to and is saved with the workbook. Perhaps make a template with your customized palette and other common features for your pivots. Regards, Peter T "JanHDon" wrote in message ... I have a series of pivot table charts--one for all employees, and individual ones. I want to give the projects the same color legend across all the charts. I've tried changing the legends, one-by-one, then saving the chart, then moving to the next iteration, but when I go back to the first chart, the colors have returned to the defaults. What am I missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reset chart names | Charts and Charting in Excel | |||
Reset Colors Option gone from Excel 2007? | Excel Discussion (Misc queries) | |||
Reset should give a warning before resetting custom colors. | Setting up and Configuration of Excel | |||
excel fill and font colors won't reset to default | Excel Discussion (Misc queries) | |||
Excel reset colors does not work. | Excel Discussion (Misc queries) |