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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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,919
Messages
6,122,259
Members
449,075
Latest member
staticfluids

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