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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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 :(
 
Upvote 0

Forum statistics

Threads
1,214,527
Messages
6,120,058
Members
448,940
Latest member
mdusw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top