can you make crosshairs on a chart in excel?

J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
A line chart 3
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Adding a line to a population bar chart 0
Data points in chart incorrect 0
How do I adjust marker spacing in Excel scatter plot? 1
Numbering Data Points on Chart 2

Top