• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

UAE Map Chart

Hui

Excel Ninja
Staff member
It is important to know what do you want to do with it ?

If you want to map locations against it, do you want the data in UTM or WGS84 format?
If you want to simply color the states that isn't important

You also want cities ?
 
Hi,

I want to show revenue in these cities - Dubai,Abudhabi,Sharjah within UAE.

I dont want any map locations in it.

Thank you so much.

Regards,


It is important to know what do you want to do with it ?

If you want to map locations against it, do you want the data in UTM or WGS84 format?
If you want to simply color the states that isn't important

You also want cities ?
 

Hui

Excel Ninja
Staff member
Have you considered using Power Map instead?

It will take addresses as Map References and allow plot of 3D Columns, Contour or shade graphs etc
 

chirayu

Well-Known Member
Either what Hui said or a Choropleth in Excel. Example below but same principles apply

 
No - I have not tried Power Map.Is it possible to share sample file.

Thanks in advance

Have you considered using Power Map instead?

It will take addresses as Map References and allow plot of 3D Columns, Contour or shade graphs etc
 
Hi,

How to do choropleth chart for UAE?


Either what Hui said or a Choropleth in Excel. Example below but same principles apply

 

Chihiro

Excel Ninja
We could do sample of PowerMap, but first need to know if you have access to the add-in and what version of Excel that you are using.

As for Choropleth, you'll want base map of UAE in either WMF or EMF format.

Go to following site to get free map of UAE (found in Asia -> United Arab Emirates) download the WMF format file, pick one with borders but with no additional coloring or labels as base map.
https://d-maps.com/
 
Top