Microsoft Office Tutorials and References
In Depth Information
Adding a new series using the Source Data dialog box
Figure 3-2: Using the Paste Special dialog box to add a series to a chart
If the first column of your range selection included category labels, make
sure that the Categories (X Labels) in First Column check box is selected.
If you want to replace the existing category labels, place a checkmark in
the Replace existing categories check box.
Adding a new series using
the Source Data dialog box
The Source Data 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
Source Data to display the Source Data dialog box.
3. Select the Series tab.
4. Click the Add button and then use the range selector controls to specify
the cell for the Name (optional), Values, and Category axis labels
(optional). See Figure 3-3.
5. Click OK to close the dialog box, or click Add to add another series to
the chart.
Adding a new series using
the Add Data dialog box
Excel provides yet another way to add a new series: the Add Data dialog box.
Search JabSto ::




Custom Search