Data Bars

Data bars are visual indicators within pivot table cells, allowing for quick comparison and analysis of values. They offer an intuitive representation of relative values, making it easier to identify trends, outliers, and patterns at a glance.

• Adding Data Bars to the pivot table
• Formatting Data Bars
• Formatting Combined Visuals (Databars with Sparkline)
• Conditional Formatting for Data Bars

Adding Data Bars to the Pivot Table

1. Drag-and-drop the required fields to the columns, rows, and data shelves.
2. From the toolbar, click the Data Bars icon or open the More options (⋮) menu.
3. Choose one of the following options from the drop-down.

• Only Data - This is the default case, where only the data is generated according to the columns dropped in the designer shelf.
• Only Sparkline - Displays only the Sparkline of the selected column without the values.
• Only Data Bars - Displays only the Data Bars of the selected column without the values.
• Data Bars With Data - Displays both the Data and the Data Bars of the selected column.

Formatting Data Bars

Analytics Plus allows you to customize the appearance of Data Bars to suit your data visualization needs better.

To format the Data Bars, follow the below steps.

1. At the top-right corner, click the Settings icon. The Settings page will open.
2. Click Data Bars.
3. Type: Analytics Plus offers the following Data Bar types:

• Bar: Displays a standard horizontal bar, with its length proportional to the data value.
• Waterfall: Shows progressive bars to represent changes across time, stages, or categories.
• Data: Displays only the data values without bars.

4. Color: Choose a color that best suits your Data Bars.

• Additional Formatting Options: Click on the Vertical Ellipsis (three dots icon) to access the Additional Options window.

  

• Data and Bar Sequence: Click the drop-down to choose the display sequence between Data and Bar. This option is only enabled when the Data Bars With Data option is selected. Analytics Plus provides the following options:

  • Data and bar – Displays the data first, followed by the bar.
  • Bar and data – Displays the bar first, followed by the data.
  • Overlapped – Displays the data overlaid on the bar.

  

• Bar alignment: When Bar type is selected, you can align the bar either left, right, or middle. When Waterfall is selected, you can align the data bar either left or right.
• Data alignment: When the Data Bars With Data option is selected, you can align the data either left, right, or middle.

• Preview: The Preview space allows you to instantly see how different Data and Bar alignment or sequence appear in your pivot table.
• Negative bar color: Choose your preferred color for the data bars having negative values.
• Data Bars shown in: Select checkboxes to show Data Bars in Data, Row Grand Total, and Column Grand Total.

5. Enter your preferred height value in pixels for the cells of Data Bars in the Data Bars Cell Height box.

After customization, the data appears as follows:

Formatting Combined Visuals (Data Bars with Sparkline)

When you select Data Bars with Sparkline, the formatting options are available under the Visuals section in the Settings panel.

1. Click the Settings icon at the top-right corner.
2. Open the Visuals tab.
3. For each data column, choose the required visual.
4. Customize the color and cell height as needed. The pivot table updates instantly to reflect the changes.

Conditional Formatting for Data Bars

Analytics Plus allows you to apply conditional formatting directly on Data Bars. This lets you highlight bars that meet specific conditions, making it easier to track outliers or key thresholds at a glance.

To apply conditional formatting:

1. Right-click on any data cell and select Conditional Formatting.

   

2. On the Conditional Formatting dialog, define the rules based on your criteria.

3. Choose a color for the Data Bars that meet the condition.

   

4. The Data Bars in your pivot will now change color dynamically based on the conditions you set, giving you deeper insight without losing the visual comparison of bar lengths.