Me.Controls.AddChart(Me.Range('D2', 'H12'), 'Chart1')Ĭhart1.SetSourceData(Me.Range('A1', 'B5'), )Ĭhart1.ChartType = 3DColumnĭim axis As Excel.Axis = CType(Chart1.Axes(, _Į), Excel.Axis)įor information on optional parameters, see Optional Parameters in Office Solutions.
(this.Range,Ĭhart1.SetSourceData(this.Range,Ĭhart1.ChartType = 3DColumn Įxcel.Axis axis = (Excel.Axis)chart1.Axes(ĭim Chart1 As .Chart = _ The following code example creates a Chart and then uses the Axes method to add a title to the primary axis. Add or remove a secondary axis in a chart for Mac 2016 I would like to create a chart like this on Excel for Mac 2016 When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. If this argument is omitted, the primary group is used.
