| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Graphs
I have a pivot table. Every period I refresh the data. The grpahs that I
created change every time I refresh. So I have to do the format of the graph all over again. Is there a way to prevent this. Thanks. |
|
#2
|
|||
|
|||
|
Unfortunately, loss of formatting is a known problem with pivot charts.
There's information in the following MSKB article, which suggests recording a macro as you apply the formatting: Changing a PivotChart Removes Series Formatting in Excel http://support.microsoft.com/?id=215904 Conditional Formatting wrote: I have a pivot table. Every period I refresh the data. The grpahs that I created change every time I refresh. So I have to do the format of the graph all over again. Is there a way to prevent this. Thanks. -- 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 | |||
| graphs showing unwanted zero values | Excel Discussion (Misc queries) | |||
| Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
| 2 graphs on 1 single chart cheet | Charts and Charting in Excel | |||
| Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
| Graphs and sheet referencing? | Excel Worksheet Functions | |||
Linear Mode
