# Pin charts Pin charts, also known as lollipop charts, are commonly used to display and compare data. It is 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. ### 1. Adding the chart Inforiver offers three variants of pin charts: *Simple, Bar colored*, and *Marker colored*. In this example, we will visualize the 'Margin%' using a pin chart. **Step 1:** We have added 'Category' and 'SubCategory' in the **Rows** field, and 'Sales', 'Margin', 'Margin %', and 'Total Customers' in the **Values (AC)** field in the visualization pane.

**Step 2:** 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**.

**Step 3:** The simple pin chart gets inserted as shown below. You can see the 'Customize' tab in the toolbar and the following [customization options](https://docs.inforiver.com/working-with-inforiver/6.-working-with-charts/bar-and-pin-charts#2.-customization-options).

### 2. Customization options Inserting a pin chart will open up the following configuration options. ### 2.1..Chart type Here you can change your current chart type. Inforiver offers three variants of pin charts: **Simple Lollipop**, **Bar Colored Lollipop** and **Marker Colored Lollipop**.

### 2.2. Axis config This option lets you configure the axis for the chart. Clicking on the **Axis Config** option will open up the 'Axis modal' in which you can configure the following properties: * **Axis direction** - From this drop-down, you can set the direction of the axis to either 'Left to Right' or 'Right to Left' * **Show Y Axis** - Enable this check box if you want to display an axis on the Y Coordinate * **Show X Axis** - Enable this check box if you want to display an axis on the X coordinate * **Hide ticks** - With this option, you can either show/hide tick intervals

### 2.3. Reference line Reference lines are horizontal or vertical lines that are added to a chart to indicate a specific value or threshold. Using this option, you can add a reference line for values such as average, median or set a custom value. Clicking on this option will open up a **Reference line** modal to the right of the report.

Click on the 'Add New Line' button in the modal. This will open up a toolbar as shown below.

You can customize the following options in the reference line modal: **a) Value display -** This option has two dropdowns. From the first drop-down, you can select the data metric for which you want to display the reference line. And the second drop-down lets you select the value at which the reference line needs to be inserted. You can select from the following values: 1. **Average -** Inserts a reference line at the average value of the data metric 2. **Median -** Inserts a reference line for the median value of the data metric 3. **Standard deviation -** Inserts a reference line for the standard deviation of the data metric 4. **Mid value -** Inserts a reference line at the mid value of the data metric 5. **Constant -** If you select this option, an additional 'Static value' field becomes available. Using this option, you can set the static/constant value at which you want to insert the reference line.

**b) Style -** This option has three dropdowns. From the first drop-down, you can choose the style of the reference line. You can choose from any of the following options: *Dotted, Dashed, Solid, Long Dashed,* or *Double Solid*. From the second drop-down, you can select the color of the reference line. And from the third drop-down, you can choose the position of the reference line. It has the following two options: *Front* - positions the reference line in front of data values, and *Back* - positions the reference line to the back of the data values.

After choosing all the customizations, click on 'Apply' to insert a reference line with chosen customization options.

**Add more than one reference line** - To add more than one reference line, you can click on the 'add new trend line' link at the bottom of the toolbar in the reference line modal.

**Delete a reference line** - To delete an existing reference line, click on the trash can/delete icon.

**Disable a reference line** - To disable an existing reference line, click on the toggle switch button.

### 2.4. Reference band Reference bands are similar to reference lines, but they are represented as a shaded area between two lines. They are used to indicate a range of values. Clicking on this option will open up a **Reference Band** modal.

From this modal, you can customize the following options **a) Value Display -** This option has two dropdowns. From the first drop-down, you can select the data metric for which you want to display the reference band. And the second drop-down lets you select the ending value of the reference band. You can select from the following options: 1. **Average -** The average value of the data metric is set as the ending value of the reference band 2. **Median -** The median value of the data metric is set as the ending value of the reference band 3. **Standard deviation -** The standard deviation of the data metric is set as the ending value of the reference band 4. **Mid value -**The mid value of the data metric is set as the ending value of the reference band 5. **Constant -** If you select this option, an additional 'Static Value' field becomes available. Using this option, you can set the static/constant value which is set as the ending value of the reference band.

**b) Start From -** Using this drop-down, you can select the starting value of the reference band. It has the following options: 1. **Min** - The minimum value of the data metric becomes the starting value of the reference band 2. **Zero** - Zero becomes the starting value of the reference band

3. **Constant** - If you select this option, a new input field becomes available where you can select the constant value which becomes the starting value of the reference band.

**c) Line Style -** The line style option allows you to set the style and color of the lines that get displayed at the starting and ending value of the reference band. From the first drop-down, you can choose the style of the lines. You can choose from the following options: *Dotted, Dashed, Solid, Long Dashed,* and *Double Solid*. And, from the second drop-down, you can select the color of the lines.

**d) Background color** - This color picker lets you choose the color for the shaded area in the reference band. **Delete reference band** - To delete an inserted reference band, click on the 'Delete' button at the bottom of the 'Reference Band' modal.

### 2.5. Outliers This option lets you indicate the outliers that exceed the specified threshold values. In the customization menu, click on the **Outliers** option.

In the Outliers pop-up window, click **Enable Outlier.** The labels are visible by default, to hide them, uncheck the **Label option.**

* **Type** - This dropdown lets you configure the **Outlier** range as **Negative/Positive Threshold** or **Min/Max Threshold.**

Enter the required **Negative/Positive** or **Min/Max** threshold values as shown below and Click **Apply**.

After applying outliers, the report shows below, highlighting the Margin values exceeding 1000k.

### 2.6. Data label config This option lets you configure the properties related to the data label. You can configure the following properties: * **Data label -** This checkbox lets you show/hide data labels. Note that other options become available only if this option is enabled. * **Data label flip** - With this option, you can reverse/flip the positions of the data labels. By default, the labels are placed to the right of the bar. By enabling this option, you can flip/reverse their position to the left with respect to the bars.

* **Show label** - In this drop-down, you can select the format of the data label. You can display the data values as just **Value (numbers)**, as **Percentages**, or as **Both**. * **Percentage scaling** - This drop-down gets enabled only if you have chosen 'Percentage' or 'Both' as the data format in the show label drop-down and when the chart contains hierarchical levels. Using this option, you can configure the scaling of the percentage data label. The available scaling options are 1. **Universal - This** is the default option, and it indicates the percentage contribution of the value to the grand total. 2. **By level -** Whereas 'By level' indicates the percentage contribution of the value to its parent level or category.

### 2.7. Fill pattern You can customize the fill pattern to any of these IBCS notations: **Solid***,* **Outlined***,* or **Hatched**.

### 2.8. Appearance Appearance has two sub-options - **Color** and **Series display**.

**a) Color -** This option lets you define properties such as the bar color, axis color, data label color etc. 1. **Positive color** - Using this option you can customize the positive color of the bar/marker 2. **Negative color** - Using this option you can customize the negative color of the bar/marker 3. **Axis color** - This option lets you set the axis color of the chart

**b) Series display** - This option lets you select the marker type and marker size. 1. **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**. 2. **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**.

### 2.9. Measure Scaling This option lets you select the measure scaling of the chart. By default, **Universal** **Scaling** is applied. **a) Universal** - In this option the scaling of the chart is fixed based on the consolidated min and max values from all the measures. For reference the consolidated min value is '13.05' and max value is '778.51' from all the measures, therefore the scaling of the chart is fixed based on these values.

**b) Individual** - In this option the scaling of each individual measure is fixed based on their own Min and Max values.

In this section, we covered pin charts. Navigate to the next section to learn more about the [change/deviation charts](/working-with-inforiver/6.-working-with-charts/change-deviation-charts.md). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/working-with-inforiver/6.-working-with-charts/pin-charts.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.