How can I add a new line in Excel 2007 Graph

[ashwin2012]

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

[Koman]

You can do that with the help of following steps.

1. First right click in the graph.
2. Then in the options, select Data. You can now see the Data Source window.
3. Highlight the extended range of data you want to include in your graph (including the new data) > OK.
4. The 6th line should get added to your graph.

[AnitG]

Copy the data >> select the chart >> paste special >> add as new series (selecting appropriate options).