Microsoft Office Tutorials and References
In Depth Information
Adding a New Series to a Chart
Following are some pointers to keep in mind when you add a new series using the Paste Special
➤ Make sure that the New Series option is selected.
➤ Excel will guess at the data orientation, but you should verify that the Rows or Columns
option is guessed correctly.
➤ If the range you copied included a cell with the series name, ensure that the Series Names in
First Row/Column option is selected.
➤ If the first column of your range selection included category labels, make sure that the
Categories (X Labels) in First Column/Row check box is selected.
➤ If you want to replace the existing category labels, select the Replace Existing Categories
Adding a new series by extending the range highlight
When you select a series in a chart, Excel displays an outline around the data used by that series.
When you select something other than a series in a chart, Excel displays an outline around the entire
data range used by the chart — but only if the data is in a contiguous range of cells.
If you need to add a new series to a chart (and the new series is contiguous with the existing chart’s
data), you can just drag the blue range highlight to add the new series. Start by selecting any chart
element except a series. Excel highlights the range with a blue outline. Drag a corner of the blue
outline to include the new data, and Excel creates a new series in the chart.
Adding a new series using the Select Data Source dialog box
The Select Data Source dialog box provides another way to add a new series to a chart, as follows:
1. Click the chart to activate it.
2. Choose Chart Tools ➜ Design ➜ Data ➜ Select Data to display the Select Data Source
3. Click the Add button to display the Edit Series dialog box.
4. Use the range selector controls to specify the cell for the Series Name (optional) and Series
Values (see Figure 6-3).