Microsoft Excel: Copy worksheet data into a chart sheet

You may have gone to the Chart menu and used the Add Data… option to add another series to your chart. But, did you know there’s an easier way?

1. On the worksheet, select the cells that contain the data that you want to add to the chart and copy.
2. Click the chart into which you want to paste the copied data.
3. You can paste the data or use Paste Special on the Edit menu to select the options that you want. Special options include adding the cells as a new series or point(s), display the values in rows or columns, and if a series or category name is included in the selection.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.