Range Bar Charts

Range bar charts visualize the difference between two values for each category, showing both the start and end points as bars.

Use a range bar chart to compare numeric ranges across several items—such as project durations, sales targets, budget periods, or actual versus planned metrics. This chart type emphasizes the size of each range and highlights gaps or overlaps between items, making it easier to compare category at a glance. Choose range bar charts when your data includes minimum and maximum values or spans that need clear visual representation.

Example use cases

example

• Sales performance analysis: Visualize the range between minimum and maximum monthly sales for each region or sales representative, helping identify performance variability.
• Budget versus actuals: Compare budgeted and actual expenditures for various departments or projects, quickly highlighting overspending or savings.

Range Bar types

	Chart	Description
	Range Bar	Displays vertical bars to compare start and end values for each item.
	Horizontal Range Bar	Displays horizontal bars. Use when labels are long or items are numerous.

Create a range bar chart

1. Select Data Models and Views from the navigation panel.
2. Right-click the data model you want to use and select New View from the context menu.
3. In the Select a View dialog, select Range Bar or Horizontal Range Bar from the Bar category.
4. Enter a Name for the view. To assign names in other languages, select the translation icon next to the text box.
5. Select the fields you want to include for each section.
6. (Optional) Toggle Sample Mode to preview the data using a sample dataset.
7. Click Confirm. The new view opens with your initial settings.
8. Customize the view by using the view organizer, content area, and Toolbar.
9. In the Toolbar panel, select Save or Save As to save your changes.

Range Bar settings

Setting	Description
Name	Enter a descriptive name for the worksheet. Select the translation icon to add labels for different languages—ideal for multilingual environments.
Sample Mode	Enable to open the worksheet in sample mode.
Define the Levels to be Used in Drill Down	Select which fields support drill-down functionality in the chart.
Starting bar values are	Choose the field that defines the start point of each bar.
Ending bar values are	Choose the field that defines the end point of each bar.
Show pivot (group of columns) for each	Select dimensions to include in the Pivots section of the view organizer. These values pivot the worksheet layout, letting you compare data across different dimensions. Selecting a field for Pivots is not required to create a worksheet.