Microsoft Office Tutorials and References
In Depth Information
Chapter 6: Working with Chart Series
In This Chapter
Adding and removing series from a chart
Finding 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
Unlinking a chart from its data
Using secondary axes
Every 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 select and modify the data used in your charts.
All workbook examples in this topic are available on the companion website for this
On the Web
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.