View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Save graph formatting

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.

"Gary Brown" wrote:

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" wrote:

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

"Gary Brown" wrote:

Have you tried unclicking the checkbox for 'AutoFormat table' in the
PivotTable Options window?
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Teresa" wrote:

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.