Hello folks,
Sigh... I would like to draw a horizontal line across a graph, with the Y=axis value coming from a cell (so it can be altered).
I have spent hours and hours looking at threads about this, and doing what they say to, but nothing really works.
The basic method I have been following is to "create a defined name" "with a reference to ={1,1}<sheet+cellreference>" then in the graph create a new data set "=SERIES(,,<definedname>,1)"
This ALMOST works, except I get a line drawn from X-axis "1 to 2" not across the entire graph.
I would greatly appreciate any help I can get!
- Thomas
Bookmarks