Thread: Data Series Question

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.28zo80_1149611415.8663@excelforum-nospam.com> wrote in
message news:Raman325.28zo80_1149611415.8663@excelforum-nospam.com...
>
> 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