moving a pivot table graph and keeping the formatting

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

Guest

When you move a pivot table graph to a new workbook the formatting will
change. How can I keep the exact formating of the graph?
 
Hi Mr Rick,

Right-click the worksheet Tab, select 'Move or Copy' from the context menu.
Then select another workbook and check the 'create a copy' option.
The whole sheet will copy across, pivot tables will keep their formats.

Hope you all had a great Christmas, and Happy New Year to you.
Ed Ferrero
http://www.edferrero.com
 

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

How do I keep formatting when creating a chart from a pivot? 1
Dynamic graph issue 2
Pivot Table Resutls Don't Match the Graph 2
Pivot table creates stacked column 2
Graph Line Width ? 1
Excel 2003 Graphs 2
Pivot Tables & Pivot Charts 1
Why is the graph invisible when I move it to a "new sheet"? 1

Back
Top