Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Plot and Name Map Coordinates in Excel

0

I have three columns: column A contains the name of the point (Point 1, Point 2, etc) column B contains the Easting(x) and column C contains the Northing(y).

I want to be able to format for 200 points but not have the blank points show in a legend.

I have tried to create x,y plots but seem to be required to enter each point separately. Additionally, it seems Excel wants to put each one in a legend, even if there is no data associated.

Is there a less tedious way to do so?  Thank you.

excelcharts
MS Office Version: 13
posted by: neo on Thu Mar 23, 2017 at 4:44 pm
Answer
Discuss

Answers

0

Hi there!

Why not just sort the data so the empty values are on the bottom and then select the other values to be on the chart?

posted by: cappymer1 (rep: 120) on Sat Mar 25, 2017 at 6:55 am
Discuss

Discussion

Thank you for your response; however, my main issue is the graphing of the points themselves.  In completing the graph points there is the series name, the x value and series y value.  If each point is its own series with its own name, how can I enter the data in one entry rather than entering each one separately?  Is it possible without using vba?
Again thank you for the suggestion.
neo Mar 27, '17 at 9:45 am
Update your question and provide a sample file. I'm sure the solution is not difficult, but it'd be easier to see exactly whats going on.
cappymer1 (rep: 120) Mar 28, '17 at 5:58 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login