| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i stop the colors changing on my pivot chart when i refres.
How do i stop the colors changing on my pivot chart when i refresh the pivot
table? |
|
#2
|
|||
|
|||
|
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: XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 kev from uk wrote: How do i stop the colors changing on my pivot chart when i refresh the pivot table? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Graph Title W/ Pivot | Excel Discussion (Misc queries) | |||
| Pivot and changing External data source | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
| In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) | |||
| Changing colors of tabs | Excel Discussion (Misc queries) | |||
Linear Mode
