Changes the format of the active chart to one of six built-in combination chart types.
Syntax
COMBINATION(type_num)
COMBINATION?(type_num)
Type_num is a number corresponding to the combination chart you want.
| Type_num | Result |
| 1 | Column chart overlaid by a line chart |
| 2 | Column chart overlaid by a line chart with an independent y-axis scale |
| 3 | Line chart overlaid by a line chart with an independent y-axis scale |
| 4 | Area chart overlaid by a column chart |
| 5 | Column chart overlaid by a line chart containing three data series (for showing stock volumes related to high, low, and closing prices) |
| 6 | Column chart overlaid by a line chart containing four data series (for showing stock volumes related to open, high, low, and closing prices |
Related Functions
FORMAT.MAIN Formats a main chart
FORMAT.OVERLAY Formats an overlay chart
Return to index