can you make crosshairs on a chart in excel?
 

can you make crosshairs on a chart in excel?
 

Add a series with one point, where the X and Y values of this point locate
the intersection of the horizontal and vertical crosshairs. If it isn't
already an XY type, convert it. Add X and Y error bars with appropriate
custom values to reach the edges of the chart. You'll have to lock in the
scale min and max parameters.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RobGrn" wrote in message
...

can you make crosshairs on a chart in excel?
 

Hi,

I posted this for a previous question.
http://www.andypope.info/ngs/ng26.htm

Cheers
Andy

RobGrn wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info