Save graph formatting

[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.

 

[Gary Brown]

Have you tried unclicking the checkbox for 'AutoFormat table' in the
PivotTable Options window?

 

[Teresa]

Thank you, that was helpful, now I just need to know why I don't have the
option to uncheck it.

 

[Gary Brown]

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

 

[Teresa]

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.