Palisade DocumentationBigPicture 2016 Manual Map BasicsHow do I link a topic label to a range?

How do I link a topic label to a range?

You can make a topic label dynamic by linking it to a single-cell or even a multiple-cell range. Then if those cell contents change, the topic label will update automatically. This is especially useful if the range contains formulas that change when input data change.

Enter values and/or formulas in a range

Here is an example where the revenue from a sale is based on the four inputs above it.

Enter values and/or formulas in a range

Method 1: Select the range via the Label option

Right-click the topic to bring up the shortcut menu and choose Label.

Right-click the topic to bring up the shortcut menu and choose Label.

Click and drag to select the range for the label

In this case, the revenue and the label to its left have been selected.

Click and drag to select the range for the label

Method 2: Specify the range via the Topic Pane

Click the Topic button on the BigPicture ribbon

Click the Topic button in the View section of the BigPicture Ribbon. This opens the Topic Pane on the right, where you can make many types of changes to any of the topics.

Click the Topic button on the BigPicture ribbon

Select the Label From Excel Range and click and drag to select the range for the label

Select the Label From Excel Range option, click the button to its right, and click and drag to select the range.

Select the Label From Excel Range and click and drag to select the range for the label

View the result

The label appears, aligned nicely, although you might need to resize the topic.

View the result

Change data in the linked range

It's dynamic! Any changes you make that change the linked range are reflected automatically in the topic label. Here the number of units sold has been changed from 3 to 5.

Change data in the linked range

Try using a larger linked range

Substitute the smaller selection above with a bigger one in either of the methods described.

Select several labels and the corresponding numbers

Select several labels and the corresponding numbers

View the result

Again, the contents of the topic label are aligned nicely, although you might need to re-size the topic.

View the result

Select non-contiguous columns of data to create/label multiple topics at once

After selecting your range of data when creating new topics from cells (See #1), or when labeling a topic from cells, you can <Shift> click OK (#2) to specify the # of cells per topic label (#3).

In the following example we selected non-contiguous columns of data and asked BigPicture to use all 21 cells to label 1 topic. The resulting topic puts the 3 columns that were selected into one topic. (#4)

Select non-contiguous columns of data to create/label multiple topics at once

(Optional) Change to a static label

If for any reason you want to change from a dynamic (linked) label to a static (unlinked) label, it is easy to do so.

Open the Topic Pane and select the Simple Label option

Click OK to confirm this action

Open the Topic Pane and select the Simple Label option

View the label and change it if necessary

The contents of the linked cells are automatically used for the simple label. No typing is necessary unless you want to modify the label in some way.

View the label and change it if necessary