How do I combine two worksheets into one graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining a 2-D column graph and a 2-D line graph on the same char 3
Charting multiple worksheets 2
I don't want to graph "null" values? 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Access Combination Chart Types Access 2010 0
Mixing scatter plot with a category plot 2
Excel Deleting embedded graphs during worksheet copy 2
Pivot Table Resutls Don't Match the Graph 2

Back
Top