Graph in Excel

[Guest_imported]

I would like to draw graph with the following data. The first two cloumns are the geographical location of a point and the third column are the data represents an Id of the transmitter and the fourth column represent the strength in DB of signal transmitted by the transmitter at that point.

Latitude (North) Longitude (East) cellId Strength
100.1 200.2 1234 43
100.1 200.2 6421 23
100.1 200.2 7865 33
100.1 200.3 1234 42
100.1 200.3 6421 24
100.1 200.3 7865 34
100.1 200.4 1234 41
100.1 200.4 6421 26
100.1 200.4 7865 35
100.2 200.2 1234 44
100.2 200.2 6421 22
100.2 200.2 7865 34
100.2 200.3 1234 43
100.2 200.3 6421 22
100.2 200.3 7865 34

I want to display a graph showing the coverage of the transmitters with highest strength, X and Y axis representing the Logitude and Latitude. Each transmitter should be represented by a different colour. Also if a user click at any point, all the data (transmitter id's and their strengths) should be shown.

Can anyone advice me on the type of graph to be used and how to do it.

Thanks in Advance.

 

[Guest_imported]

Mistake while typing:

Its

"strength in DB of signal of the transmitter"

Instead Of

"strength in DB of signal transmitted by the transmitter"

 

[snyderj]

Using XL2K you could order your columns as follows:

long lat strength
200.2 100.1 43
200.2 100.1 23
200.2 100.1 33
200.3 100.1 42
200.3 100.1 24
200.3 100.1 34
200.4 100.1 41
200.4 100.1 26
200.4 100.1 35
200.2 100.2 44
200.2 100.2 22
200.2 100.2 34
200.3 100.2 43
200.3 100.2 22
200.3 100.2 34

Select the data, insert a chart of type 'bubble', and set series to columns. However, I don't know how to make the Cell ID as a lable for each bubble. You can make each bubble a different color by right-clicking a bubble, Format Data Series, Options tab, select 'vary colors by point'.

Is this something close to what you're seeking?