Chart Type changes when I pivot

  • Thread starter Thread starter Kenneth Andersen
  • Start date Start date
K

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.
 
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.
 
Back
Top