Data Series Question

[Raman325]

Hi,

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

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

The purpose was to show .67 for each entry on the graph. This worke
without error. I wanted to do a similar thing with the other tw
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

 

[David Biddulph]

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.

 

[Raman325]

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