Constant horizontal line on a chart (based on a single value)
Posted by Skewer on July 18, 2001 11:22 AM
Image the scene, you want a graph showing stuff but there is an ideal value or range of values (as in cost, weight, etc).
How can I get a single value (already calculated elsewhere) or values to generate horizontal lines so at a glance the approach towards (or fluctuation between) certain values is visible?
I could just draw an autoshape over the graph I guess but then how could I get that to move around?! Surely there's a chart method that doesn't involve a hidden row(s) containing solely absolute references to this value in its calculated location?