Graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table. Every period I refresh the data. The grpahs that I
created change every time I refresh. So I have to do the format of the graph
all over again. Is there a way to prevent this.

Thanks.
 
Unfortunately, loss of formatting is a known problem with pivot charts.
There's information in the following MSKB article, which suggests
recording a macro as you apply the formatting:

Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save graph formatting 4
Access Form Refresh 1
Using VLOOKUP when referencing data from Access 2
refresh option of pivot table not working 1
Pivots and Functions 3
Automated show and hide chart 4
Selective Graphing 1
GRAPHS 1

Back
Top