Hi,

This may be a stupid question, and I'm not exactly sure how to phrase
it, so I apologize in advance if I am unclear. I am trying to create a
line graph which has four Data Series. One series comes from a list of
data in the worksheet. Another series is a constant number, so I just
made a set like so:

Series = "={.67,.67,.67,.67,.67}"

The purpose was to show .67 for each entry on the graph. This worked
without error. I wanted to do a similar thing with the other two
series, but I wanted it to reference a particular cell. I tried doing:

Series = "={F10,F10,F10,F10,F10}"

This gave me an error, however. Is this possible to do, and if so, how?
Thanks for your help!


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=549068

"Raman325" wrote in
message ...

Hi,

This may be a stupid question, and I'm not exactly sure how to phrase
it, so I apologize in advance if I am unclear. I am trying to create a
line graph which has four Data Series. One series comes from a list of
data in the worksheet. Another series is a constant number, so I just
made a set like so:

Series = "={.67,.67,.67,.67,.67}"

The purpose was to show .67 for each entry on the graph. This worked
without error. I wanted to do a similar thing with the other two
series, but I wanted it to reference a particular cell. I tried doing:

Series = "={F10,F10,F10,F10,F10}"

This gave me an error, however. Is this possible to do, and if so, how?
Thanks for your help!

Have you tried sheetname!F10 instead of just F10?

If , while you are editing your Data Series, you click in the relevant cell
at each stage, it'll hopefully do the job for you.
--
David Biddulph

Wow, I thought of trying to select cells, but since I waslooking for the
same cell each time, I didn't know how to test it. I just realized I can
just select multiple cells individually to try. Thank you David for your
suggestion


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=549068