Microsoft Office Tutorials and References
In Depth Information
Adding a New Series to a Chart
Dealing with numeric category labels
It’s not uncommon to have category labels that consist of numbers. For example, you may create a
chart that shows sales by year, and the years are numeric values. If your category labels include a
heading, Excel will (incorrectly) interpret the category labels as a data series and use generic
category labels that consist of integers (1, 2, 3, and so on). The following figure shows an example.
You can, of course, choose Chart Tools➜Design➜Data➜Select Data and use the Select Data Source
dialog box to fix the chart. But a more efficient solution is to make a simple change before you
create the chart: Remove the header text above the category labels! The following figure shows the
chart that was created when the heading was removed from the category label column.
Adding a New Series to a Chart
Excel provides four ways to add a new series to an existing chart:
➤ Copy the range and then paste the data into the chart.
➤ Use the Select Data Source dialog box.
➤ Select the chart and extend the blue highlighting rectangle to include the new series.
➤ Activate the chart, click in the Formula bar, and manually type a SERIES formula.
Search JabSto ::

Custom Search