itipu
04-13-2010, 01:57 PM
Hi All,
Lots of articles on this one, yet I can't seem to get it to work with my graph.
Graph is attached, basically I'd like to see a solid line at 500, so that to see which value points are above and which are below..
I tried adding a new series (see Data sheet) called HorizontalLine and then using Error Bars and all other things advised if you google for this very topic.. but none of it really works.. Is it at all possible..
I know that drawing a solid line and just moving it to 500 would work, but can't see how you can automate that as basically once I can figure this one out (if at all), I will record a macro and do some vba..
Thanks for your thoughts!
Mike
Lots of articles on this one, yet I can't seem to get it to work with my graph.
Graph is attached, basically I'd like to see a solid line at 500, so that to see which value points are above and which are below..
I tried adding a new series (see Data sheet) called HorizontalLine and then using Error Bars and all other things advised if you google for this very topic.. but none of it really works.. Is it at all possible..
I know that drawing a solid line and just moving it to 500 would work, but can't see how you can automate that as basically once I can figure this one out (if at all), I will record a macro and do some vba..
Thanks for your thoughts!
Mike