![how to make scatter chart in excel 2010 how to make scatter chart in excel 2010](https://icdn3.digitaltrends.com/image/screen7a-720x720.jpg)
Even if I had known all that in advance, though, I wouldn’t think to go to the Insert menu to add labels to the chart. Even after fooling with charts a while, I’m still blundering through things like exactly what sequence of actions is necessary to make a chart editable, what I need to do to alter the scale on the axes, and so forth.
How to make scatter chart in excel 2010 how to#
The way to select and unselect charts, and how to modify their properties, is really unintuitive, I’m afraid. I probably would not have solved this on my own.
How to make scatter chart in excel 2010 Pc#
The good news is, someone has written a little utility which will label XY scatter plots in Excel, both for PC and Mac ( here’s another link). This has been a limitation in Excel for many years, and so many people want this feature, I wonder why they aren’t implementing it.
![how to make scatter chart in excel 2010 how to make scatter chart in excel 2010](https://i.stack.imgur.com/EGDxJ.png)
A bit of Googling revealed lots of other frustrated folks with the same problem. We tried and tried but couldn’t get Excel to plot the points with nice labels next to them. The first column in the spreadsheet is the point’s name. Of course, when you’ve got hundreds of points on the map, you want them labelled so you can see what they are, like so:
![how to make scatter chart in excel 2010 how to make scatter chart in excel 2010](https://www.statisticshowto.com/wp-content/uploads/2013/08/scatter-plot.png)
This gives a quick sense of what the map looks like. For a quick and dirty map of the data, it’s great to import it into a spreadsheet, select the Northing and Easting columns, and map it as a scatter plot. Recently we took a total station out to a cemetery and mapped it, then downloaded the data as tab-separated values. I’ve been working with cemetery data again. txt, open the file, and then do Data->Text To Columns. The only way we’ve found is to rename it to something else such as. No matter what we do in the Open dialog, including choosing “All Readable Files,” it leaves CSV files grayed out.
![how to make scatter chart in excel 2010 how to make scatter chart in excel 2010](https://i.ytimg.com/vi/BjsjAbvbWao/maxresdefault.jpg)
Both of us have tried all the ways we know. It runs OSX, and the “About Excel” dialog says “Excel X for Mac” (can you tell what a dummy I am when it comes to Mac? The only thing that saves me is the presence of the Terminal, so I can resort to the command line to do things). Maybe someone else can answer this one for me, because I’m stumped and can’t seem to find the right search phrase to turn up relevant results in Google: I can’t get Excel to open a. I’ve learned some more interesting things about both spreadsheets, as regards opening CSV files and adding labels to XY scatter charts (spoiler: both spreadsheets have problems) In an earlier post I compared number formatting in Excel vs.