K
Keith R
a status update, although it still isn't working.
I basically want to switch between 2 ranges that populate my graph(s),
which means i can figure it out after I get my first two ranges working-
one range is my actuals and the other is the X-Axis.
I've gone ahead and put some stuff in cells instead of in named ranges, and
this still doesn't seem to work:
I have one cell that drives a VLookup, and populates the following two
lines based on whether I enter "1" or "2"
"1":
OH2!$C$8:$C$31 (actuals)
OH2!$A$8:$A$31 (x axis)
"2":
OH2!$C$49,OH2!$C$20:$C$31 (actuals)
OH2!$A$7,OH2!$A$20:$A$31 (x axis)
Then my named ranges take those cells (lets say they are in cell A1 and A2,
respectively)
Named range: KeithActual =indirect(Sheet1!A1)
Named range: KeithXAxis =indirect(Sheet1!A2)
The only difference I've detected from making the graphs from scratch with
hard references, is that there is an extra set of parenthesis in the source
data/series, for example:
=(Info!$H$23,Info!$C$25:$C$30)
=(Info!$A$20,Info!$A$25:$A$30)
so I also tested things like:
Named range: KeithActual ="(" & indirect(Sheet1!A1) & ")"
but nothing works...Help!
Many thanks,
Keith
I basically want to switch between 2 ranges that populate my graph(s),
which means i can figure it out after I get my first two ranges working-
one range is my actuals and the other is the X-Axis.
I've gone ahead and put some stuff in cells instead of in named ranges, and
this still doesn't seem to work:
I have one cell that drives a VLookup, and populates the following two
lines based on whether I enter "1" or "2"
"1":
OH2!$C$8:$C$31 (actuals)
OH2!$A$8:$A$31 (x axis)
"2":
OH2!$C$49,OH2!$C$20:$C$31 (actuals)
OH2!$A$7,OH2!$A$20:$A$31 (x axis)
Then my named ranges take those cells (lets say they are in cell A1 and A2,
respectively)
Named range: KeithActual =indirect(Sheet1!A1)
Named range: KeithXAxis =indirect(Sheet1!A2)
The only difference I've detected from making the graphs from scratch with
hard references, is that there is an extra set of parenthesis in the source
data/series, for example:
=(Info!$H$23,Info!$C$25:$C$30)
=(Info!$A$20,Info!$A$25:$A$30)
so I also tested things like:
Named range: KeithActual ="(" & indirect(Sheet1!A1) & ")"
but nothing works...Help!
Many thanks,
Keith