Forum Discussion
Map Chart Series Color Customization
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.
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.
