ExcelBanter - How do I combine two worksheets into one graph

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do I combine two worksheets into one graph (https://www.excelbanter.com/charts-charting-excel/192-how-do-i-combine-two-worksheets-into-one-graph.html)

McPowerUser

How do I combine two worksheets into one graph

I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?

Jon Peltier

Make a chart with data from one sheet. Then copy the data on the other sheet, select
the chart, and use Paste Special from the Edit menu to add the copied data as New
Series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

McPowerUser wrote:

I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?

All times are GMT +1. The time now is 01:44 PM.