Creating a Pinboard

  To create a pinboard:

  1. Open spreadsheet with a traffic lighting definition.

  2. Select Display, then Pinboard.

    Note:

    If a pinboard is defined for the document, it is displayed as a result of your selection. When no pinboard is defined, the Pinboard Designer is displayed. To edit a Pinboard, right-click the data object and select Edit Pinboard.

    Pinboard Designer is displayed, automatically displaying column dimension members as pins and traffic lighting ranges as pin colors in the Select Pin Images group.

  3. In the Image Source group, click Set Background.

    The Open dialog is displayed.

  4. Navigate to a GIF or JPEG file to use as the background. Select the file name, and click OK.

    The selected image is displayed in the Pinboard Designer panel.

  5. Optional: To set the image to fill the Pinboard panel, select Stretch to Fit.

  6. Optional: To change the dimension member selections, perform one:

    • Click the Member Selections list to select other traffic lighted column dimension members.

    • Click Add Members to display the Dimension Browser, and change dimension member selections.

    • Click Add Calculations to create pins from calculated members.

    • Right-click a pin and select Delete Pin, to remove pins without redefining the member selection statement.

  7. Optional: To specify to hide pins with null values, select Hide Null Pin.

  8. Optional: You can also select a special color for pins with null values, by clicking Select Null Pin Color.

    The Select Null Pin Color dialog box is displayed, enabling you to select a color, and click OK. See Selecting Color. The selected color is displayed in the box beside the button, after selection.

    The specified dimension members are rendered with default pins on the Pinboard panel. The Select Pin Images group reflects the traffic lighting range colors. You can also specify pin images that differ for each traffic lighting range, or a different part of the current pin image to reflect the traffic lighting range color.

    See Creating Image Pins, or Creating Color Pins.

  9. Drag pin images on the Pinboard background to position them.

  10. Click Pinboard Designer OK to display the finished pinboard.