Hi,

I forgot to mention that you could also consider upgrading to Excel 2007
where this problem has been eliminated.

Here is some additional sample code if the pivot chart is in a worksheet:

Private Sub Workbook_SheetPivotTableUpdate(ByVal Sh As Object, ByVal Target
As PivotTable)
Sh.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(2).ChartType = xlColumnClustered
Range("A1").Select
End Sub

--
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