| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save graph formatting
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save graph formatting
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save graph formatting
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save graph formatting
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel save as pdf multiple sheets - graph resized | Excel Discussion (Misc queries) | |||
| Graph formatting | Charts and Charting in Excel | |||
| How to save a graph as jpg file in Excel 2007 | Charts and Charting in Excel | |||
| how do i save an excel graph as an image file for use on the inter | Charts and Charting in Excel | |||
| How do I save a graph in eps format in excel?? | Charts and Charting in Excel | |||
Linear Mode
