| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create single chart with data from seperate worksheets
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
