Pin charts

Pin charts, also known as lollipop charts, are a variation of bar charts where a dot represents the data point and a segment connects it to the X-axis. It is often used to visualize data where the length of the bar is not as important as the value itself.

ii) Pin chartsInforiver offers three variants of pin charts: Simple, Bar colored, and Marker colored.In this example, we will visualize the 'Margin%' using a pin chart.a) We have added 'Sub Category' in the 'Rows' field, and 'Sales', 'Margin', 'Margin %', and 'Total Customers' in the 'Values (AC)' field in the visualization pane.​Data mappingb) Select the column for which you want to insert the pin chart. In the following image, the margin % column has been selected.The pin chart option gets enabled. From the 'Pin chart' drop-down, select the 'Simple pin chart'.​Column and chart type selectionc) The simple pin chart gets inserted as shown below. You can see the 'Customize' tab in the toolbar and the followingcustomization options.Inserting a simple pin chart

vi) Outliers

In the case of lollipop/pin charts, you can indicate the outliers that exceed the specified threshold values.

You can do this while creating a pin chart, or add them after creating a pin chart through the Customize tab.

1. Select the measure and then select the 'Pin Chart' drop-down menu to add any of the pin chart options available. You can also select the measure that already has one.

Click on Pin Charts drop-down menu

1. In the customization menu, click on the Outliers option.

Click Outliers

1. In the Outliers pop-up window, check Enable Outlier. If you wish to hide the values, select the option Disable Label. Enter the required positive and negative threshold values as shown below and Click Apply.

Custom Outliers

1. After applying outliers, the report shows below, highlighting the profit values exceeding 15k.

Outliers

B) Series display

The following options can be accessed by clicking on the 'Series display' option in the case of pin charts.

Series display option in appearance

a) Marker type - You can set the marker type for your pin chart(s) using this option. The marker type drop-down has the following options: Square, Diamond, and Circle.

b) Marker size - This drop-down lets you configure the size of the marker in your pin charts. It has the following options: Mini, Small, Medium, and Large.

Marker type and size options

In this section, we covered bar and lollipop/pin charts. Navigate to the next section to learn more about the change/deviation charts.