Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
tclbeach
 
Posts: n/a
Default How do I create 1 chart from 2 different sheets?

Using Excel 2003 how do I create one pie chart by using data from 2 different
sheets? all of the examples i see are created by clicking and dragging data
from one sheet.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish
 
Posts: n/a
Default How do I create 1 chart from 2 different sheets?

Jon Peltier has instructions for charting data from different sheets:


http://www.peltiertech.com/Excel/Cha...entSheets.html

tclbeach wrote:
Using Excel 2003 how do I create one pie chart by using data from 2 different
sheets? all of the examples i see are created by clicking and dragging data
from one sheet.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
able to automatically create a chart in Excel tamccann Charts and Charting in Excel 2 November 3rd 05 04:13 AM
How to create a chart based on a 2 dim data range dynamical in 1 d Beertje Charts and Charting in Excel 1 October 25th 05 11:54 AM
Macro to Create a Chart and Update it Automatically maperalia Charts and Charting in Excel 2 October 21st 05 05:42 PM
Create a combo chart with two of the same chart types Mark Parent Charts and Charting in Excel 2 October 14th 05 01:28 AM
how to create a chart in excel with data from another workbook Charlene Charts and Charting in Excel 2 October 7th 05 04:56 AM


All times are GMT +1. The time now is 11:25 PM.

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"