Hi,

This tells me you are using 2003 or earlier, in that case everytime you
refresh your pivot chart will revert back to an area chart. The only
automated solution would be to use VBA.

Let's suppose that the chart is on its own chart page then:

Private Sub Chart_Calculate()
ActiveChart.SeriesCollection(2).Select
ActiveChart.SeriesCollection(2).ChartType = xlColumnClustered
End Sub


1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find your chart sheet under
your file name and double click it.
3. Paste in or type the code above.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Ken" wrote:

Excel2003 ... I created a Pivot Table Area Chart with 2 Data Series ... I
wish to change 1 of the Data Series to a Column Bar Chart.

Issue ... each time I re-run the Pivot Chart ... it reverts back to the old
Style where both Data Series are an Area Chart.

Above said ... I selected 1 of the Data Series & changed Chart Type to
COLUMN ... Looked fine until I made another selection ... then Chart
re-verted back.

Now looking for guidance from this board ... Thanks ... Kha