Pivot Chart

[Jakob Austgulen]

I have a chart from a pivot table, and I have one graph with "hard" line,
to fokus on that.

Every thime I oppdate pivot table, my graphics change back to original chart
(I lose my "Hard line").

How can I "save format" in the chart?

 

[Andy Pope]

Hi Jakob,

This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904

Cheers
Andy

 

[HS Hartkamp]

I myself do not like things done by computers that are controlled by the
program (and thus not by me) so when I have a graph based on a pivottable, I
usually copy the content of the pivot to another range, and base the graph
on that second range. When the pivot changes, the second range changes, and
the graph changes, but the graph-layout does not change.

With this, you loose certain 'pivot-chart' features (e.g. hiding values with
drop-down boxes), but I don't use these features anyhow.

Bas Hartkamp