Excel: Plot order total in map coordinates
- by Phliplip
I have a set of data that looks like this:
-X--Y----Amount-
AE 24 $178,00
Y 27 $162,00
AD 34 $680,00
AK 35 $178,00
Y 25 $29,00
U 23 $178,00
X 38 $193,00
AC 30 $226,00
AK 39 $152,00
AJ 34 $217,00
AC 35 $183,00
AA 22 $211,00
Z 19 $172,00
AJ 32 $187,00
AF 26 $272,00
AI 27 $220,00
AJ 34 $320,00
AB 32 $183,00
AB 35 $272,00
AC 32 $207,00
AB 28 $178,00
AC 30 $168,00
AC 28 $178,00
AB 32 $310,00
AD 30 $188,00
AB 35 $188,00
The sample above is only an excerpt of the total dataset of 16K rows
Each row represents a single delivery order, where the 2 first columns are the map coordinate and the third the purchase amount.
Would it be possible to plot the above data in a chart or coordinate system. Where the each plot should be a summary of all sales in the same map coordinate.
Also a similar chart of order count would be nice to have.