"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