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
 
Back
Top