Hi,
I have created a pivot chart based on a pivot table in my excel file. I have amended the way that the graph has automatically been formatted. Amongst other things I have changed the colour and the weight of the lines on the graph. Now, if I change one of the data items to be displayed in the underlying pivot table, the formatting reverts back to the original excel chosen autoformat.
Is there a way that I can get excel to remember my changes? Or a way for me to change the default autoformat for graphs in excel?
Thanks a lot,
Caroline
Bookmarks