| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a chart from multiple worksheets
I'm trying to create a chart using the same cell reference in several
worksheets. Does anyone know a quick way to do this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a chart from multiple worksheets
Do you want to make one chart from several references, from different sheets,
OR do you want to make a chart in several worksheets (copying the chart) referring to the same cell references, but in different sheets? Henk "lissaski" wrote: I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a chart from multiple worksheets
I'm looking to make on chart from several different worksheets using the same
cell reference from each sheet. I was trying to find a shortcut (formula) I can enter into the chart wizard. I tryed selecting the cell reference and then holding the shift key to highlight the other worksheets (=!sheet1:sheet4!$B$3) but it gives me an error. Any ideas? "HEK" wrote: Do you want to make one chart from several references, from different sheets, OR do you want to make a chart in several worksheets (copying the chart) referring to the same cell references, but in different sheets? Henk "lissaski" wrote: I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a chart from multiple worksheets
Read the link I posted. You probably will have to construct a helper range
on another sheet to hold the data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "lissaski" wrote in message ... I'm looking to make on chart from several different worksheets using the same cell reference from each sheet. I was trying to find a shortcut (formula) I can enter into the chart wizard. I tryed selecting the cell reference and then holding the shift key to highlight the other worksheets (=!sheet1:sheet4!$B$3) but it gives me an error. Any ideas? "HEK" wrote: Do you want to make one chart from several references, from different sheets, OR do you want to make a chart in several worksheets (copying the chart) referring to the same cell references, but in different sheets? Henk "lissaski" wrote: I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a chart from multiple worksheets
"HEK" wrote: Do you want to make one chart from several references, from different sheets, OR do you want to make a chart in several worksheets (copying the chart) referring to the same cell references, but in different sheets? Henk "lissaski" wrote: I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a chart from multiple worksheets
http://peltiertech.com/Excel/ChartsH...iffSheets.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "lissaski" wrote in message ... I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| Line chart from multiple worksheets | Charts and Charting in Excel | |||
| Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Hybrid Mode
