Microsoft Office Tutorials and References
In Depth Information
Using Combination Charts
4. Press F9.
5. Press Enter, and the range references will be converted to arrays.
Repeat this procedure for each series in the chart. This technique (as opposed to
creating a picture) enables you to continue to edit the chart. Note that you can also
convert just a single argument to an array. Highlight the argument in the SERIES
formula and press F9.
Excel imposes a 1,024-character limit to the length of a SERIES formula, so
this technique will not work if a chart series contains a large number of
values or category labels.
Using Combination Charts
A combination chart is a chart that combines two or more different chart types —
for example, a column chart and a line chart.
Creating combination charts
Perhaps the most common way (but not the best way) to create a combination chart
is to use the Chart Wizard and select one of the custom chart types. Excel offers a
choice of only three combination charts:
Column – area
Line – column
Line – column on two axes
Many users don’t realize that Excel can create many other types of combination
charts. The trick is to create a standard chart first and then modify the chart type
setting for one or more of the series: Click the series, choose Chart
Chart Type, and
then select the chart type for that series. When you need to create a combination
chart, there is really no reason to start with one of Excel’s custom chart types —
unless it happens to be exactly what you’re looking for.
It’s important to understand that the ChartChart Type command works
differently, depending on what is selected when you issue the command. If a
chart series is selected, this command changes the chart type for that series
only . If any other chart element is selected, this command changes the chart
type for the entire chart .
Search JabSto ::




Custom Search