Series.ChartType (Excel)

Returns or sets the chart type. Here you can find possible values for XlChartType.

Some chart types aren't available for PivotChart reports.

ActiveChart.FullSeriesCollection(1).ChartType = xl3DArea