How reference multiple sheets in a formula
 

I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....

How reference multiple sheets in a formula
 

99% sure you can't do it without code.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Rick" wrote:

I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....

How reference multiple sheets in a formula
 

make the chart with one, then simply add series to put in data from
other sheets

Rick wrote:

I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....

How reference multiple sheets in a formula
 

I want the data to be all in the same series.....

"Bob I" wrote:

make the chart with one, then simply add series to put in data from
other sheets

Rick wrote:

I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....

How reference multiple sheets in a formula
 

You can't, or at least it doesn't look like you can to me. I just
tried this. Wrote a UDF to return a single range object, then used it
in a defined name and tried to put the defined name into the Series
formula of a line... Excel says it's invalid.

Public Function RangeUnion(ParamArray rngs() As Variant) As
Excel.Range
Dim l As Long
Dim retVal As Excel.Range

For l = LBound(rngs) To UBound(rngs)
If retVal Is Nothing Then
Set retVal = rngs(l)
Else
Set retVal = Union(retVal, rngs(l))
End If
Next l

Set RangeUnion = retVal
End Function

You'll probably need to to copy your data into a single worksheet, in
a single column (or row) then make the chart.


On Feb 8, 3:04 pm, Rick wrote:
I want the data to be all in the same series.....

"Bob I" wrote:
make the chart with one, then simply add series to put in data from
other sheets

Rick wrote:

I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....

How reference multiple sheets in a formula
 

Then pick a "master sheet" to provide the "cells" that the series will
point to, and in those cells, reference the scattered data.

Rick wrote:

I want the data to be all in the same series.....

"Bob I" wrote:


make the chart with one, then simply add series to put in data from
other sheets

Rick wrote:


I trying to make a chart with data that that s on multiple sheets How do I
select the data? I searched for an answer for this for 2 hours now....