BigPicture Example Series: Sales By Country Map

In the BigPicture Example Series, we’ll show you different ways you can make BigPicture work for you.  You can check out all these example files with your copy of the BigPicture software, which you can download here. Get BigPicture today and start playing with these fun and informative example models. The possibilities are limitless!

The Sales By Country Map example illustrates a company’s analysis of product sales by country and by sales region. Data from cells in the Sales By Country sheet are automatically used in the BigPicture map on the Map sheet.

sales by country data sheet BP--zoom

The map also makes use of the Markers feature of BigPicture. Markers provide additional information about topics, and they appear as icons below topics. Note the use of country flags as markers for topics that are displayed at the country level, and numeric markers for topics that are at the regional sales level.

salesbycountrymapBP

There are several ways you can add markers to the map:

Right-click a topic:   This brings up the BigPicture shortcut menu, where you can hover your mouse over the Markers command and choose a marker from one of the built-in lists of BigPicture markers.

Use the Outline pane:   If the Outline pane is open (by clicking the Outline button in the View section of the BigPicture ribbon), you can get to the same shortcut menu by right-clicking a topic in the outline.

Use the Topic pane:   If the Topic pane is open (by clicking the Topic button in the View section of the BigPicture ribbon), you can select a topic and then choose a marker in the Topic pane via the drop-down menus for each marker list.

To change a marker that has been used for a particular topic, click on the desired topic to select it, click the Topic button in the ribbon to display the Topic pane on the right, and click on Markers in the Topic pane to display a table of available marker lists and the marker that is assigned to the topic. You can use the drop-down lists to easily change the marker, or add markers from multiple lists. Alternatively, you can also right-click on the topic, hover your mouse over the Markers command in the BigPicture menu, and you will see a check mark next to the marker that is in use from the appropriate markers list. Just select a new marker from the list.

 

Check out the full example model in BigPicture’s ‘Example Spreadsheets’ section under the Help menu:

BP example files location

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s