I would like instructions on how to add a new line to an existing graph (that already has 5 lines), using Excel 2007. The data is already in my spreadsheet. Thanks
I would like instructions on how to add a new line to an existing graph (that already has 5 lines), using Excel 2007. The data is already in my spreadsheet. Thanks
You can do that with the help of following steps.
- First right click in the graph.
- Then in the options, select Data. You can now see the Data Source window.
- Highlight the extended range of data you want to include in your graph (including the new data) > OK.
- The 6th line should get added to your graph.
Copy the data >> select the chart >> paste special >> add as new series (selecting appropriate options).
Bookmarks