software that can do this?

Associate
Joined
8 Dec 2004
Posts
1,970
Location
Paignton, Devon
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.
 
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

BubbleChartMap.png

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.
 
Back
Top Bottom