creating a map location and generating a transparent circle

Leighton Durham

New Member
Joined
Sep 8, 2020
Messages
28
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
  7. 2007
Platform
  1. Windows
ok so...
for some context I am running a business that requires me to know locations and work zones depending on ones address. the idea is I put in the address, work aria radius name ext then it will generate a small red circle with the name of the person, address (possibly with a hover menu to show more details like phone number and contact details) and a large transparent circle dependent on the radius inputed. any idea on how I could accomplish this? (if its required most if not all locations will revolve around Australia Qld Shailer park and some surrounding aria.)

in conclusion:
I need a map that will show coverage radius of Shailer park using inputs of information.
I will need:
- a map
- information about the person recorded (preferably in a drop down menu or hoverable pop up)
- work radius on map
- ability to add every address in Shailer park
extra features:
- total cover radius of Shailer park in percentage
- make the map able to be zoomed in and out
- infinitely expandable (allows me to add effectively every address in Shailer park and extended beyond)
- small conditional formatting

thanks i look forward to seeing your ideas
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,126,998
Messages
5,622,097
Members
415,876
Latest member
csibonga2k17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top