Keep format of an excel pivotdiagram

  • Thread starter Thread starter Anders Juul
  • Start date Start date
A

Anders Juul

Dear newsgroup.
I usually spend quite some time to format excel-diagrams (based on
pivottables) to my black-and-white printer.
And every time I press "Update" or change data the standardformat comes back
(coloured lines and markers).

1) Is it possible to stop this?
2) Is it possible to make b/w-formatting a standard?

Regards
Anders Juul
 
Anders

Hi, I am having a similar problem. I have a pivot chart
with a page field whereby I can choose a number of
datasets to present. I set the format to the way I want -
lines on 2 axis - but when I change the field setting it
returns to the default. I have tried to set the line on 2
axis as default but this does not work.

Not much help to you but maybe somebody can help.
 
Jimy -

From the Excel Chart FAQs at Tech Trax:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon026

When a pivot table or pivot chart is refreshed, or the layout of the
pivot is changed, or individual items in a pivot field are hidden,
custom series formatting in the chart may be lost. This is because Excel
removes series from the pivot chart, then adds them back with default
formatting. Even Microsoft suggests recording a macro to apply your
custom formatting, then rerunning the macro after changing the pivot table.

XL2000: Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904

Pivot charts suffer from additional shortcomings. There are limited
chart types available to pivot charts, and you cannot add data from
outside the underlying pivot table to the chart. These issues can be
worked around by creating a regular chart from dummy data, then changing
the data ranges of the chart's series to refer to parts of the pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Personally,
If I'm viewing a PivotChart of monthly sales, and change the month that I'm viewing I don't feel it's unreasonable to ask that the format of the chart stay the same.

The reasoning behind why the formatting changes is fine - but I shouldn't have to run a macro every time I 'slice and dice' my data. And my boss sure isn't going to.

(this is not intended as an attack on anyone. I am feeling the same pain as the rest of you, and hope Microsoft hears our cries of anguish.... And there are a lot, as I scream every time my formatting vanishes.)

Jason Puchyr
 
Jason -

You can make it less painful if you record the macro, then locate a
button near the pivot table or chart, or actually on the chart if it's
in the default chart sheet configuration. Assign the macro to the
button. When you adjust the pivot table or chart, the button is right
there, and it only takes one additional click.

I know it's a pain. I looked forward to upgrading to Excel 2000 so I
could use pivot charts, but once I'd played with my third or fourth one,
I decided they weren't worth the bother.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top