using the PIVOT TABLE and CHART

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

Guest

When using the pivot table and chart in excel, I want to format the chart to
have distinct data series formats. However, when I change the selection in
the pivot table, the charting formats return to the defaults. I want to keep
this chart formatting regardless of how many time the data displayed is
changed. Is this possible?
 
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
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

Pivot Table Chart? 4
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Pivot Chart Data Labels Disappear 1
Pivot Chart Trendline? 0
Pivot Table Chart Format 1
Pivot Chart Bar Chart? 1
Pivot Tables/Charts and common filter 1
Pivot Table Charts - Help Required 1

Back
Top