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.
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.
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: