My Data is not Showing up Properly

[jennhaggs13]

Hello experts, I am having issue with a scatter plot graph that I am trying to make in excel. I am comparing woodpecker holes to the elevation at which they were found at. I was told by my instructor to place the holes on the y axis and the elevation on the x axis. However, in doing so I am getting a weird graph that I cannot understand....

I am not understanding why the values on the x-axis are showing up the way that they are considering that I have no data that has anything to do with the data values given for the x-axis...

Below is the data:

Elevation	Holes
2,690	1
2,587	5
2,545	3
2,512	3
2,501	1
2,480	1
2,670	4
2,535	4
2,560	2
2,500	3
2,490	1
2,540	2
2,530	1
2,552	3
2,565	2
2,500	2
2,520	1
2,532	2
2,640	4
2,488	2
3,088	6
3,044	1
3,053	1
3,028	2
3,023	1
3,007	3
3,025	1
3, 002	2
3,065	3
3, 020	1
3, 010	3
3,025	3
3,011	2
3, 015	6
3,016	2
2,800	1
3,000	4
2,085	2
2,081	1
2,777	1
2,756	6
2,722	7
2,750	1
2,744	1
2,743	1
2,745	1
2,720	1
2,722	2
2,757	1
2,770	1
2,742	1

<!--StartFragment--> <colgroup><col width="65" span="2" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

Any help or direction would be appreciated...

I would just like to understand why the values are showing up the way that they are and HOW I can correct it so that the x-axis values reflect the data...

Thank you!
P.S. Using Excel 2011 for MAC

 

[JoeMo]

The image you tried to post doesn't show up. You would improve your chances of getting some help by elaborating on exactly how the values are appearing on your graph.

 

[jennhaggs13]

If you copy and paste it into a browser does it now show up?

 

[jennhaggs13]

I'm sorry if it is not showing up.... obviously I am new to this forum and the only way to attach an image is to get a url not a direct upload via computer...

 

[Jim Gordon]

First off, the data is “dirty.” There are spaces in some of the values that must be removed. Maybe they are an artifact of pasting into the question, but they must be removed before you attempt to make your chart. Once I cleaned up the data, all I did was to click the Charts tab of the Ribbon and chose the Marked Scatter chart to make my chart. It looks OK to me.