Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Working with Chart Series
Chapter 3
Working with Chart Series
IN THIS CHAPTER
Adding and removing series from a chart
Various ways to change the data used in a chart
Using noncontiguous ranges for a chart
Charting data from different worksheets or workbooks
Dealing with missing data
Controlling a data series by hiding data
Using names in SERIES formula
Unlinking a chart from its data
Creating combination charts and using secondary axes
E VERY CHART CONSISTS OF AT least one series, and the data used in that series is
(normally) stored in a worksheet. This chapter provides an in-depth discussion of
data series for charts and presents lots of tips to help you modify the data used in
your charts.
Specifying the Data for Your Chart
When you create a chart, you almost always start by selecting the worksheet data
to be plotted. Normally, you select the numeric data as well as the category labels
and series names, if they exist.
If you use the Chart Wizard to create your chart, you can then select a chart type
and get a preview of how the selected data appears using the specified chart type.
When creating a chart, a key consideration is the orientation of your data: by rows
or by columns. In other words, is the data for each series in a single row or in a
single column?
Excel attempts to guess the data orientation by applying a simple rule: If the
data rows outnumber the data columns, then each series is assumed to occupy a
column. If the data columns outnumber the data rows, then each series is assumed
to occupy a row. In other words, Excel always defaults to a chart that has more
categories than series.
57
Search JabSto ::




Custom Search