Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I would like to create a chart using data from several worksheets.
Basically, each worksheet graphs data for a different time period. For example SHEET1: Store : Customers : Sales : Margine Data : Data : Data : Data SHEET2: Store : Customers : Sales : Margine Data : Data : Data : Data etc. I would like to be able to create a chart using say, the sales data. (SHEET1:Sales:Data, SHEET2:Sales:Data). Is there a way to select the datarange from seperate Worksheets? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
You can chart data from different sheets or workbooks together, subject to
certain constraints. Generally the easiest way is to combine the data onto a single sheet (linking it, of course), and plotting this data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "MATT" wrote in message ... I would like to create a chart using data from several worksheets. Basically, each worksheet graphs data for a different time period. For example SHEET1: Store : Customers : Sales : Margine Data : Data : Data : Data SHEET2: Store : Customers : Sales : Margine Data : Data : Data : Data etc. I would like to be able to create a chart using say, the sales data. (SHEET1:Sales:Data, SHEET2:Sales:Data). Is there a way to select the datarange from seperate Worksheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a chart in Excel using data from two worksheets | Charts and Charting in Excel | |||
Need to create chart from data in 2 columns and not sure how. | Charts and Charting in Excel | |||
create a chart using two columns for x & y, third for line data | Charts and Charting in Excel | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
Setting up data to create a chart | Excel Worksheet Functions |