Macro Sheets Only
Changes the chart type for a selected data series, a group of data series, or an entire chart.
Syntax
FORMAT.CHARTTYPE(apply_to, group_num, dimension, type_num)
FORMAT.CHARTTYPE?(apply_to, group_num, dimension, type_num)
Apply_to is a number from 1 to 3 specifying what part of a chart the new chart type effects.
Value Part of chart
1 Selected data series
2 Group of data series
3 Entire chart
Group_num corresponds to the number of the group you want to change as listed in the Group list box of the Chart Type dialog box, which appears when you choose Chart Type from the Format menu while a chart is active. Groups are numbered starting with 1 for the group at the top of the list. This argument is required if apply_to equals 2; otherwise it is ignored.
Dimension specifies whether to apply a 2D- or 3D-chart type. Use 1 for a 2D chart type or 2 for a 3D chart type. If omitted, uses the same dimension as the series, group, or chart to be changed.
Type_num specifies the chart type to apply. Meaning of type_num varies depending on the value of dimension:
Type_num Chart type if dimension is 1 Chart type if dimension is 2
|
1 |
Area |
3D area |
|
2 |
Bar |
3D bar |
|
3 |
Column |
3D column |
|
4 |
Line |
3D line |
|
5 |
Pie |
3D pie |
|
6 |
Doughnut |
3D surface |
|
7 |
Radar | |
|
8 |
XY (scatter) |
Related Functions
FORMAT.CHART Formats the selected chart
List of Command-Equivalent Functions