Microsoft Office Tutorials and References
In Depth Information
Adding a new series using Paste Special
If you find that you can’t drag your data, choose ToolsOptions and click the
Edit tab of the Options dialog box. Make sure that the Allow Cell Drag-and-
Drop option is enabled.
The drag-and-drop procedure described previously is actually equivalent to the
following copy-and paste-procedure:
1. Select the range that contains the data.
2. Choose Edit
Copy.
3. Click the chart to activate it.
4. Choose Edit
Paste.
In fact, you can use these commands to add a new series to a Chart sheet.
Adding a new series using Paste Special
For more control when adding data to a chart, you can use the Paste Special
command. Specifically:
1. Select the range that contains the data that will comprise the new series.
Include the cell that contains the series name, if applicable.
2. Choose Edit
Copy.
3. Click the chart to activate it.
4. Choose Edit
Paste Special, which displays the Paste Special dialog box.
5. Specify your choices and click OK.
Figure 3-2 shows a new series (using data in column D) being added to a line
chart.
Following are some pointers to keep in mind when you add a new series using
the Paste Special dialog box:
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 option is selected.
Search JabSto ::




Custom Search