Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
McPowerUser
 
Posts: n/a
Default 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?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is the order of my data table opposite from graph? mozermodo Charts and Charting in Excel 6 April 25th 23 03:43 AM
How do I graph text information in Excel garrison0013 Charts and Charting in Excel 5 April 3rd 23 03:41 PM
Y Axis - Horizontal Bar Graph Eagle Charts and Charting in Excel 1 December 9th 04 01:24 AM
Problem with graph ranges No Such Luck Charts and Charting in Excel 6 December 3rd 04 01:09 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"