IBCS Lollipop Chart

IBCS charts conform to

IBCS (International Business Communication Standards).

IBCS charts in Pyramid compare two measures, and show only upward and downward differences between their values – you can change the color corresponding to each in the Formatting panel. Values are displayed on the chart, with the final difference on the right hand side. Additionally, you can hover over sections of the chart to display specific values at that point, and the value of the difference.

Note: Because IBCS charts compare the difference between values of two measures, you must add a second measure to the Values panel. Once you have two measures in Values, click on the button corresponding to the IBCS chart type you want. The second measure is moved to a separate panel, called Additional Values:

See the Lollipop Chart page for more information on creating a Lollipop chart:

The above chart shows turnover for a period of several months, comparing it with the operating budget, which is represented by the line running along the middle of the chart (indicated by the purple arrow). The turnover fluctuates, in some months being less than the budget, as represented by the red lines on the chart - the green lines represent months when turnover exceeded budget, The final date point on the chart also displays the amount by which the turnover exceeds the budget (orange arrow). Hover over any point on the chart to display the actual turnover, the budget, and the difference (delta) between them.

To display the difference between the measures correctly, you must use the IBCS theme. This is available in the themes in the Design tab,

IBCS Formatting

The Formatting panel for IBCS charts includes an IBCS tab to assist in chart formatting:

Under this tab, you can change the colors used to display Upwards and Downwards differences, choose whether to display a difference arrow, and format it.