Update Chart in Pivottable

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

Guest

Hello

I want people to be able to update a chart in my excelfile. The chart should be "Line - Column on two axes", But when they change e.g the project they want to see it switches into the "normal" format with a only columns, I guess I could record a macro that changes this back to the format I want, but isn't there a way to keep the format?
 
Loss of formatting is a known problem with pivotcharts. There's some
info in the following MSKB article, which supports your idea of
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 Chart - Disassocoation from PivotTable 1
Creating Charts using VBA 0
VBA to set the font size for the axes of a bar chart 1
controlling chart location 1
Please help! Cannot open pivotTable source file.... 2
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Changing Input to code that creates a chart 2
Chart Error when using Chart Line - Column on 2 Axes in vba code 2

Back
Top