Forum Discussion
Solved
Map Chart Series Color Customization
Dear all,
I've been trying to create this map chart for a while and I came across a problem. I'll try to explain what I've been trying to do step by step:
- I have a list of cities that are in the same country and a column of data according to these cities,
- I can insert a map chart without any problem,
- What I want to do is basically coloring each city with a solid color according to the interval of their respective data,
- I conditional formatted the data to be highlighted in a certain color (for example if data of city A is between x and y, highlight it in green) and I have 5 different intervals (which also means 5 different colors to be projected on the map chart),
- I want each city to be colored as the conditional formatting's rules color. But not like a gradient coloring, need them to be solid colors.
- I also want this to be automatic since the data has about 80 cities.
Is there any way that I can do this? I'm open to any solution.
Thanks for your help!
Hi JuliaDale1945,
experiencing difficulty saving Excel spreadsheets to your desktop can be attributed to various factors. Consider the following solutions:
1. Use the 'Save As' Option:
Try saving the file with a different name and location using the 'Save As' option. Open the "troubled" Excel workbook, click on File, select Save As, choose the location, give it a new name, and click Save.Save your workbook - Microsoft Support
2. Controlled Folder Access: Temporarily disable Controlled Folder Access in Windows Defender Security Center under Virus & threat protection settings. Check if this resolves the issue of saving to specific locations.
Allow an app to access controlled folders - Microsoft Support
Add an exclusion to Windows Security - Microsoft Support3. Repair Microsoft Office: If none of the above steps work, consider repairing your Microsoft Office installation.
Repair an Office application - Microsoft Support
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
2 Replies
To use colored categories (instead of gradients for numeric values), first add a column that contains identifiers for your categories. In my example below, it is the Century column. Edit your data series (right-click any city on your map; click "Select Data…"; select your desired - probably the only - series in the Legend Entries (Series) box; press the Edit button). Change the "Series values" to a range in the category column (and, if appropriate, change also the "Series name"). Click the "Color by secondary category names" radio button, then the OK button.
And of course, click the OK button to close the Select Data Source dialog, saving your changes.
The (gradient and non-gradient) colors for your categories are selectable from the usual chart-coloring tool.
Excel creates only choropleth maps, for which regions of the map area are colored. For mapping data for cities, it might be more user friendly to use a symbol map. Microsoft's old MapPoint software was good at this; presumably Bing Maps can do the same. Other alternatives are Google Maps (although I don't recall if you can map categories to custom icons automatically) or the website Datawrapper.de.
- Thanks for the advice! This solution was exactly what I was looking for. You're the best!
