Do you work with geographical data? By showing this information on a map the data can be understood more easily. It can be used with countries, counties or post codes.
Setting up the data for filled maps
The first step involves creating a simple summary table including a column with the geographical information and another which is numerical to show the relative sizes of the information. Once this is completed the data (including the headings is selected).
Producing the chart for filled maps
Next the Filled Maps option is chosen from the Maps icon and a map showing the data has been created. The options from this point forward are similar to those you get when a chart or graph is created but with slightly less choices. However all the options are specifically map related.
The Chart Design tab contains a lot of the most useful options.
Add Chart Element:
Chart Title – can choose where the title is situated. The text can be edited directly on the chart
Data Labels – shows a label directly on the chart. By default this shows the value but more label options allows this to be changed to the series or category name instead.
Legend – allows the location of the key to be moved
Instead of using the chart elements a few pre created layouts can be used instead.
The colours used in the key can be altered.
These are pre created styles of chart which can enhance the look of the maps
This can be used to add new data or reduce the range of data if the range of cells containing data has expanded or contracted
The chart can be moved to a sheet on its own if required.
So if the data you have is location based consider whether this type of representation is a better way to show your figures. Bear in mind that if you don’t have this feature you may not have the most up to date version of Microsoft Excel.