Data Series Question

  • Thread starter Thread starter Raman325
  • Start date Start date
R

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
 
Raman325 said:
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!
Click to expand...

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.
 
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
 
Back
Top