Pivot Tbl Chart formatting

  • Thread starter a-jlatos \(leavethisout\)
  • Start date
A

a-jlatos \(leavethisout\)

Anyone know why when I build a user defined pivot tbl
chart all the data in the second chart matches the data
in the first even though I selected different data?
Thanks in advance for the help.
J.D.
 
T

Tushar Mehta

The most reliable solution is probably a programmatic approach. Select
a PivotChart (PC) that hasn't been custom formatted. Turn on the macro
recorder (Tools | Macro > Record new macro...), go through the
formatting changes, and turn off the recorder.

Now, whenever you create a new PC, select it and run the macro created
above.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Excel does not accept text format! 0
Multiple charts from Pivot Table 0
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Refresh Pivot Chart with Table? 0
Excel 2013 Copying pivot charts to PowerPoint 0
consolidate charts from multiple pivot tables 0
new to excel 2007 how to chart this data 0
Excel 2007 Pivot charts, any way to display filters on the chart? 1

Top