J
jwa76
Hi:
I have an XY plot that refers to a set range of values on my worksheet
In this case, it is 8 rows long. I chose 8 rows because that is th
maximum number of data points that I will ever need. I have set up th
chart values so that they are dynamically calculated based on VLOOKUP
from other data. Sometimes there are only 2 data points, sometimes
or 6. The problem is that no matter how I set up the formulas, Exce
does not like the cells without values in them being included in th
chart series (I have hardwired it to include all 8 rows). I thought i
might ignore a blank ("" in the formula), but it does not, and adjust
the whole series to a "line" series (integral values of 1, 2,
regardless of my X data). First of all, is there any way around thi
issue directly, i.e. can I put a result in the cells which don't hav
data that Excel will ignore? Of course I could erase the cell
manually or set up a macro, but I am doing this on hundreds o
different worksheets.
I have also considered dynamic ranges, but I can't find any solutio
which does not involve creating named ranges, which will be ver
difficult with all the different worksheets I must create. Apparentl
Excel does not allow much in the "SERIES" keyword for its charts -
have tried INDIRECT, OFFSET, etc., without any success.
I have checked this forum (albeit somewhat superficially, as I am no
quite sure what to search for) and have not found any threads relatin
to this - if there are some, please point them out to me.
Thanks for any assistance,
John
I have an XY plot that refers to a set range of values on my worksheet
In this case, it is 8 rows long. I chose 8 rows because that is th
maximum number of data points that I will ever need. I have set up th
chart values so that they are dynamically calculated based on VLOOKUP
from other data. Sometimes there are only 2 data points, sometimes
or 6. The problem is that no matter how I set up the formulas, Exce
does not like the cells without values in them being included in th
chart series (I have hardwired it to include all 8 rows). I thought i
might ignore a blank ("" in the formula), but it does not, and adjust
the whole series to a "line" series (integral values of 1, 2,
regardless of my X data). First of all, is there any way around thi
issue directly, i.e. can I put a result in the cells which don't hav
data that Excel will ignore? Of course I could erase the cell
manually or set up a macro, but I am doing this on hundreds o
different worksheets.
I have also considered dynamic ranges, but I can't find any solutio
which does not involve creating named ranges, which will be ver
difficult with all the different worksheets I must create. Apparentl
Excel does not allow much in the "SERIES" keyword for its charts -
have tried INDIRECT, OFFSET, etc., without any success.
I have checked this forum (albeit somewhat superficially, as I am no
quite sure what to search for) and have not found any threads relatin
to this - if there are some, please point them out to me.
Thanks for any assistance,
John