Chart Type changes when I pivot

[Kenneth Andersen]

I have a PivotChart that I've created based on some data containing turnover
and profit percentages.
I show the graph in a chart type called "Curve - pillar two axes" translated
from Danish). They are under the tab "Custom types" also translated from
Danish), but it is not a chart type, I've made, it is a default type!
The chart type has turnover as primary axis, and profit percentage as
secondary axis.
When I present the data in the chart, the benefit of a PivotChart is, that I
can pivot the data, so I can analyze a certain business area, period or the
like, but when I pivot, the chart changes type to a bar without a curve ....
and now is only the turnover bars shown.
Further, I can say that chart type is not destroyed if the same file is used
in excel 2007. Thereby it must be proven that excel 2003 has a bug in this
field.

 

[Shane Devenshire]

Hi,

This was a problem with 2003 an earlier, whenever you refresh some custom
charts they may revert to a standard chart types such as in your case. This
was a know issue.