Import .CSV file and spread out over 360 points in X-axis on graph

[LRATOZ]

Hi,

I am making an application that makes up a 360 degree skyline of a site in Excel 2010.
If the site is reasonably flat I will get away with about 10 to 15 values (Azimuth and Elevation of objects in degrees).
On sites where there are lots of buildings, masts, trees, etc. it can go up to 150 or more data points for a 360 degree view.
The data is coming from a theodolite and the values are stored as a text file in two columns; Azimuth and elevation in degrees.

Now the problem is that I want to have a scale in the X-axis from 0 to 360 degrees.
When I import the data in a graph that only has, say 50 values, then the X-axis will only be showing 50 points.
I want to see the X-axis at the same scale all the time divided in 360 degrees.

Example:

I've got three points as follows:
Azimuth Elevation in degrees
18.5 20
57.3 11
185.7 6.3

So I want to see these points marked on the X-axis at the corresponding dot in the X-axis.
So the 18.5 value should be at 18 degrees on the X-axis
The 57.3 value should be at 57 degrees on the X-axis
The 185.7 degrees should be on the 185 degrees point on the X-axis
All values in between should be 0 or equal to a base line.

I've been pulling out hair for days to sort this problem. Is there anybody out there who can help?
Thanks,

Luc

 

[shg]

Use a scatter (not line) plot, and set the x axis min to 0 and the max to 360.

 

[LRATOZ]

Deleted

 

[LRATOZ]

Use a scatter (not line) plot, and set the x axis min to 0 and the max to 360.

Thanks for your help but that doesn't seem to work.
Here is how it should look like:

And here is what I got:

As you can see the 169 data points are shown but their value do not correspond to the data points where I want them
Eg. The point 138.5; 33.2 (The big spike) shows in the second graph at 65 degrees instead of the expected 138 degrees.

Here are the values, for this particular case, I want to plot:

Azimuth	Elevation in degrees
0	1.9
5.3	2.2
10.7	2.3
15.4	1.8
20.4	2.2
25.1	1.8
30.2	1.8
31.7	2.5
35.1	3.9
39.2	2.9
43	3.1
46.8	1.8
50.5	2.3
54.8	1.8
59.4	1.7
62.9	2.7
64.5	1.4
66.8	3.4
68	2.1
70.2	2.2
72.7	1.2
77.3	1.1
81.3	1
83.9	0.9
86.2	1.4
89.5	1.1
90	1.1
95.5	1.1
98.8	1.5
101.9	0.8
104.1	0.3
109	0.4
112.2	0.5
114.9	0.4
115.8	0.4
115.8	0.5
116.4	0.7
117.4	0.7
118.2	1.3
118.9	1
119.2	0.7
119.5	0.9
122.3	0.9
122.6	1
122.8	0.9
123.1	0.9
123.4	1.8
124.5	2.2
124.9	2.1
125.3	2.1
125.3	1.1
129.9	1.1
130.6	0.8
130.7	0.9
130.8	0.9
131.1	1.1
131.5	1.2
131.7	0.9
133.6	0.9
133.8	1.1
134.7	1.4
135.4	1.1
135.8	0.7
136.9	1
138.3	0.7
138.3	0.7
138.5	33.2
139	0.4
140.2	0.8
140.7	1.4
141.1	1.4
145.6	1
150.1	0.9
154.6	0.9
157.6	1.3
160.3	1.7
162	1.1
161.9	1.4
162.1	1.6
162.3	1.5
162.1	1.1
164.3	1.2
166.2	1.3
166.4	1.1
168	1.5
169.6	1.4
170.2	1.3
171.3	1.1
172	1.4
172.5	0.9
174.4	0.9
176.7	0.9
180	0.5
181.6	0.7
183.6	0.5
186.2	0.9
192.3	0.7
192.3	0.2
193	0.4
196.3	0.4
197.5	0.4
200.5	0.8
201.1	0.8
198.9	2.6
203.6	2.7
201.8	2.2
201.5	0.7
204.4	0.8
206	0.4
207.8	0.6
211.2	0.1
213.8	0.3
218.2	0.8
220.3	0.1
224.3	0
228.5	-0.3
232.1	-0.1
234.9	-0.2
238.8	-0.2
240.3	-0.1
240.3	0.4
240.8	0.9
241.3	0.4
241.3	-0.1
243.4	-0.2
246.2	-0.2
250.3	0
254.6	0.4
256.8	0.3
258.2	0.3
259.8	-0.2
264.5	-0.3
265.3	0
267.2	-0.3
270	-0.3
274	-0.4
279.4	0
282.2	-0.1
284.8	-0.1
286.8	-0.1
286.8	3.4
286.9	0.2
288.4	0.2
288.5	5.9
288.6	0.2
289	-0.1
291.3	-0.1
292.3	0.1
296.5	-0.2
299.7	-0.1
303	-0.2
307.8	-0.1
309.8	0
314.7	0.3
317.6	0.1
324.2	-0.2
328.1	0.2
332.8	0.1
337.8	0.2
342.9	0.5
347.3	0.4
350.8	0.4
346.7	15.1
351.1	16.8
355.5	15.1
351.2	11.2
351.4	0.8
354.5	1.5
360	1.9

<tbody>
</tbody>

 

[Jon Peltier]

Maybe you should make an XY Scatter chart instead of a line chart. You can format it so the points are connected as in a line chart, but the actual X values will be plotted like numerical values. You can set the X axis scale to start at 0 and end at 360.

Like this:

 

[LRATOZ]

John,

This works a treat!
Exactly how I want it.
Thank you so much for helping me out. This has saved me a lot of frustration!
Cheers,

Luc