| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Graph with pivot table
Hello
I have a custom graph which has both stacked columns bar and a line graph with pivot table. Everytime I refresh data, the graph switch to graph with colums bars. How can I lock a graph to prevent switching? Thanks a lot, R. |
|
#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: Changing a PivotChart Removes Series Formatting in Excel http://support.microsoft.com/?id=215904 Richard Vajsar wrote: Hello I have a custom graph which has both stacked columns bar and a line graph with pivot table. Everytime I refresh data, the graph switch to graph with colums bars. How can I lock a graph to prevent switching? Thanks a lot, R. -- 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 | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) | |||
| How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| How to increase the size of a Pivot Table Graph | Excel Discussion (Misc queries) | |||
Linear Mode
