Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2003 Color on Pivot Chart
In Excel 2003 I do the following:
Format Data Series Pattern Tab-Area-None Select my color Hit OK Everything is fine. The problem is when I right click my pivot info and select the "!" for REFRESH. PROBLEM: Color changes back Is there a way to keep the selected color? Thanks in advance.. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2003 Color on Pivot Chart
Hi,
This is a know problem, http://www.contextures.com/xlfaqPivot.html#ChartFormat Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ty" wrote in message ... In Excel 2003 I do the following: Format Data Series Pattern Tab-Area-None Select my color Hit OK Everything is fine. The problem is when I right click my pivot info and select the "!" for REFRESH. PROBLEM: Color changes back Is there a way to keep the selected color? Thanks in advance.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 pivot chart/table copying vs Excel 2003 | Charts and Charting in Excel | |||
Pivot chart, macro to change color | Charts and Charting in Excel | |||
How do I get a secodary axes to stay on a excel 2003 pivot chart | Charts and Charting in Excel | |||
Excel 2003- how do I keep the pattern formatting on a pivot chart? | Charts and Charting in Excel | |||
CHART COLOR SCHEMES IN EXCEL 2003 | Excel Discussion (Misc queries) |