Save graph formatting

  • Thread starter Thread starter Teresa
  • Start date Start date
T

Teresa

I have formatted my pivot graph but every time I refresh or change the pivot,
the graph reverts back to a different default. I have saved it as a default
graph.
 
Have you tried unclicking the checkbox for 'AutoFormat table' in the
PivotTable Options window?
 
Thank you, that was helpful, now I just need to know why I don't have the
option to uncheck it.
 
Not sure if this will work, but try this...
Go to the underlying pivot table that the graph is based on.
Right-click inside the pivot table to bring up a shortcut menu
Select 'Table Options'
Uncheck the 'AutoFormat Table' checkbox
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
 
Thanks, I did finally figure that out. Unfortunately it is still not
working. Not sure if it's because it's the type of graph I'm using or not.
It's a Line - Column graph. It keeps my other formating but will not keep
the graph type. Still working on it.
 
Back
Top