Bar Charts

Bar charts display data as rectangular bars, making it easy to compare values across categories. They are one of the most common and effective ways to visualize differences in quantities, trends, or proportions in business data.

Use a bar chart to highlight comparisons, spot trends, or monitor progress across departments, products, time periods, or any other business dimension.

Example use cases

example

• Sales by product: Compare total sales across multiple products or regions to identify top performers.
• Budget utilization: Visualize actual spending compared to budgeted amounts for different departments over time.

Bar types

	Chart	Description
	Vertical Bar	Displays vertical bars. Ideal for comparing values across a few categories.
	Stacked Bar	Stacks vertical bars to show both total and individual contributions.
	Stacked Bar 100%	Stacks to 100% to show percentage contributions.
	Horizontal Bar	Uses horizontal bars. Good for long labels or many categories.
	Horizontal Stacked Bar	Stacks horizontal bars to show totals and part-to-whole relationships.
	Horizontal Stacked Bar 100%	Stacks to 100% to highlight proportional differences.

Create a 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, choose a bar chart type 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.

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.
Show one bar for every	Specify the field that defines how bars are grouped—typically by product, region, or period.
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.