software that can do this?

Colbaker · 13 Dec 2014 at 14:12

Hi All,

In order to prove a point at work I am looking at creating a pictorial reference of how busy each individual branch is, I have the branch data in an excel spreadsheet but want to show it against a picture of the southeast, what im looking for is using a colour gradient graphic.

I would like the end product to be a picture of the southeast with colour gradient circles over the sites where branches are, using the excel data I would like these circles to grow and change colour relevent to the amount of customers they have.

is there a software that can do this for me? I have a feeling I would be looking at some sort of programming though.

Grrrrr · 14 Dec 2014 at 16:47

It's probably possible using excel. Create a bubble chart with a picture of a map as the background. The x y coordinates of your data should correspond to where the sites are on the map (kind of like latitude and longitude). Then your data can determine the size of the bubble. To change the colour will require vba but that shouldn't be too complicated.

izzop · 14 Dec 2014 at 16:51

If you're using Office 2013 this might be just what you're looking for: -

Microsoft Power Map for Excel

Regards

Grrrrr · 15 Dec 2014 at 10:18

Power Map is almost definitely a better solution but I'm a bit of an Excel geek and wanted to see if it was possible my way...

https://dl.dropboxusercontent.com/u/57487477/BubbleChartMap.xlsm

Colbaker · 15 Dec 2014 at 11:29

Grrrrr said:
Power Map is almost definitely a better solution but I'm a bit of an Excel geek and wanted to see if it was possible my way...

https://dl.dropboxusercontent.com/u/57487477/BubbleChartMap.xlsm

This is what i am looking for, How did you decide the X - Y axis? I have the Map picture of the Southeast of england, I have the data of the amount of customers in each of the 110 branches through the southeast but don't have any relevant x y axis details to state where each branch is located.

Grrrrr · 15 Dec 2014 at 11:47

Just trial and error really.

Switch the axes back on and you'll get two axes going from -1 to 1. Then just estimate the x-y of where each branch is.

Edit\\ Just reread, 110 times won't be fun doing it by trial and error. Sorry!