Using MSDN article: Walkthrough: Creating a Chart in Excel Based on SQL
Server Data, I want to edit Gallery to be a xl3DArea graph.
But there is no property - Gallery:=Excel.Constants.xl3DArea.
Cannot find the solution, please help.
Thanks
----------------------------------
The attached coe is:
xlChart.ChartWizard( _
Source:=cellRange.CurrentRegion, _
Gallery:=Excel.Constants.xl3DBar, _
PlotBy:=Excel.XlRowCol.xlColumns, _
CategoryLabels:=1, _
SeriesLabels:=1, _
HasLegend:=False, _
Title:=xlSheet.Name)