Pivot Chart

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

In Pivotchart, Everytime I press the refresh button,How
can I keep the same chart type I like? (but not a default
chart). Thanks.
 
XL retains only certain aspects of a customized PivotChart. One option
would be to create a macro that does the customization you want. The
other is to create a normal chart from the data in a PT.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
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

Sorting PivotChart 1
how to make grand total to show up on pivotchart? 0
How do I adjust&save the PivotChart format? 2
Pivotcharts and stored procedures 5
How to create a bubble chart with more than 2 variables 0
Remove series from Pivot Chart 2
refreshing charts 3
PivotChart Loss of Format 0

Back
Top