|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
06-16-2005, 03:05 PM
|
|||
|
|||
|
Pivot Chart
I want to maintain my selected color for the pivot chart. But, when i filter
the chart, the selected color will refresh back to default color. Any idea to keep my selected color for the pivot chart even i refresh the chart? Thanks. 
|
|
#2
06-16-2005, 03:05 PM
|
|||
|
|||
|
Re: Pivot Chart
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as you apply the formatting: Changing a PivotChart Removes Series Formatting in Excel http://support.microsoft.com/?id=215904 Jojomay wrote: > I want to maintain my selected color for the pivot chart. But, when i filter > the chart, the selected color will refresh back to default color. > > Any idea to keep my selected color for the pivot chart even i refresh the > chart? > > Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
