Crosshair on a surface contour chart

davet1234

New Member
Joined
Apr 11, 2007
Messages
9
Hi all

i have a surface contour chart showing a map i am working on. I would like to be able to enter a reference containing x and y locations and be able to diplay them on my surface contour map as a crosshair.I hope this all makes sense

Is this at all possible if so can any body help me with this matter

Many Thanks in advance

Dave T
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
since you have had on answers to your post, I will volunteer an approach to your problem, which might be totally unsuited!

Say your data starts in cell A2, and the headings in A11. Insert two new rows 2 and 3. On your chart, click on a plot point, to get to the Series Data, then click on Source Data. There, change the range from A4 to A2. Now, enter a point you want to identify on your char in the data table, usint the x,y data, in A2,B2.

Unfortunately, to see the point A2,B2, you will also see all otherpoints used for your chart, which might make this method unacceptable :(
 

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,380
Members
405,449
Latest member
Jfrusty

This Week's Hot Topics

Top