Microsoft Office Tutorials and References
In Depth Information
Creating a Combination Chart
Figure 4-30
Column chart with added data series
S&P 500 values
are shown in red
columns
Understanding the Series Function
If you select a chart’s series and look at the formula bar, the formula being displayed
uses the SERIES function. The SERIES function describes the content of a chart data
series and has the syntax
=SERIES( name , categories , values , order )
where name is the name that appears in the chart, categories are the labels that appear
on the category axis of the chart, values are the values that Excel plots for the data
series, and order is the order in which the series appears in the chart. For example, a
data series might be represented by the following SERIES function:
=SERIES(Sheet1!$D$1,Sheet1!$A$2:$A$9,Sheet1!$D$2:$D$9,3)
In this function, the name of the series is in cell D1 of the Sheet1 worksheet, the labels
are in the range A2:A9 in the Sheet1 worksheet, the data values are in the range D2:D9
in the Sheet1 worksheet, and the series is the third data series in the chart.
Note that although you can edit the SERIES function within the formula bar to make
quick changes to your chart, the function is tied to an existing chart. It cannot be used
within a worksheet cell or referenced from another Excel formula.
Creating a Combination Chart
A combination chart is a chart that combines two or more chart types in a single graph,
such as a column chart and a line chart. To create a combination chart, you select a data
series in an existing chart, and then apply a new chart type to that series, leaving the
other data series in its original format.
Search JabSto ::




Custom Search