If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pivot table chart color formatting wont stay
Hi,
I have a bar chart based on a pivot table. I have changed the colours of the bars from the default that Excel used. But if I change the values in the x/y axis e.g by unclicking one option then the default colours are restored! how can i stop this happening? e.g. I have 5 dates on the x axis, if i unselect one to dissplay only 4, the coulour for the bars of the remaining 4 all revert back to the default, weird isnt it? thanks for any help! |
#2
|
|||
|
|||
this is a knows problem with a not very effective workaround:
http://support.microsoft.com/default...;EN-US;Q215904 "confused" wrote: Hi, I have a bar chart based on a pivot table. I have changed the colours of the bars from the default that Excel used. But if I change the values in the x/y axis e.g by unclicking one option then the default colours are restored! how can i stop this happening? e.g. I have 5 dates on the x axis, if i unselect one to dissplay only 4, the coulour for the bars of the remaining 4 all revert back to the default, weird isnt it? thanks for any help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keep Pivot Table custom chart type | Jeff M | Charts and Charting | 3 | April 8th, 2005 08:58 PM |
Pivot Table Problems | Rachel Gonsior | General Discussion | 3 | March 21st, 2005 07:24 PM |
Pivot table/ Pivot chart view | TRS_JC | General Discussion | 0 | February 2nd, 2005 08:47 PM |
Pivot Table option, display as data list, repeating items down | carl.fields | Worksheet Functions | 4 | September 17th, 2004 07:57 PM |
Pivot Chart affected when refresh data | Ailing | Charts and Charting | 1 | January 15th, 2004 11:20 AM |