A horizontal bar chart is a chart where categories are displayed along the y-axis, and corresponding values are represented by horizontal bars extending across the x-axis. This format is particularly useful when dealing with long category labels, as it provides better readability compared to vertical bar charts. allowing users to quickly interpret trends and differences across categories.
Create a Chart
to add a new chart:
Within the table, click on the "+" sign above the search bar.
From the drop-down menu, select Chart view.
A box will appear to enter a name for the view—choose a descriptive name that reflects its content.
Select who can edit:
Collaborative for team access and editing.
Personal for individual use. note: you can't add it in dashboards
Click "Add".
Click Chart type .
from the list Choose Horizontal Bar Chart Chart.
Building a Horizontal Bar Chart
To create a horizontal bar chart, users must configure the following components:
Configuring a Horizontal Bar Chart: Example - Monthly Budget Analysis
To illustrate how to create a horizontal bar chart, let's build one that captures our monthly budget.
For the x-axis, we will select Transaction Date and adjust the granularity to monthly to track income trends over time.
For the y-axis, we will choose Actual Income with the Sum measure to calculate total earnings per month.
To add more context, we will apply a breakdown by Income Type, allowing us to visualize income sources within each month.
1. Define the X-Axis (Categories)
from the drop-down list choose a Column to Represents the grouping of data points.
In this example, we use Transaction Date, adjusting the granularity to monthly for time-based analysis.
2. Define the Y-Axis (Values)
from the drop-down list choose a Column to Represents the numerical values being measured.
We select Actual Income, applying the Sum measure to calculate total earnings.
3. Apply a Breakdown (Optional)
from the drop-down list choose a Column to Segments the data within each bar for deeper insights.
In this case, breaking down by Income Type provides a clearer view of different income sources each month.
Sorting is disabled when a breakdown is applied.
This setup ensures a structured and meaningful representation of income trends, making it easier to track and analyze financial performance over time.
Comparing Multiple Values (Y-Axis):
To compare Actual Income with Estimated Income, follow these steps:
Remove the breakdown (if previously applied) to allow a side-by-side comparison.
From the y-axis dropdown list, choose "Estimated Income" as the second measure.
Apply the "Sum" measure to ensure the total estimated income is calculated for each month.
Now, your monthly-based horizontal bar chart will display both Actual Income and Estimated Income, making it easy to spot differences, analyze trends, and assess financial performance at a glance.
Available Measures Based on Column Types
When selecting a y-axis column, different measurement options become available:
For Numeric Columns
Count – Counts the number of entries in the selected column.
Sum – Adds up all numerical values.
Avg – Calculates the average of the values.
Min/Max – Retrieves the smallest or largest value in the dataset.
For Non-Numeric Columns
Count ONLY – Non-numeric columns can only be counted.
Number formatting always follows the column setup within the table.
Customization & Features
The platform offers various customization options to enhance horizontal bar charts:
Sorting & Highlighting
Sort Values:
Sorts values in ascending or descending order based on the y-axis measurement.
Sorting is disabled when a breakdown is applied.
Highlight Values:
Enables highlighting of the maximum and minimum values in the dataset.
Design Customization
Column Background:
Users can add a background color for each bar segment.
Show Legend:
Displays a legend for better readability, especially useful when a breakdown is applied.
Normalization:
Ensures values are scaled proportionally for accurate comparisons.
Color Customization:
Users can change the color palette or customize bar colors individually to match specific preferences.
Filter a Horizontal Bar Charts:
Within the view, click on the funnel icon in the view bar.
A box will appear; click on "Add filter."
Three fields will be displayed:
Choose a Column
Choose a Condition
Choose a Value to Filter by
The filter will be applied directly to the view, updating the displayed data based on the selected criteria.
Sharing a Score Card
to Share Chart internally with users that have access to the Charts table:
Click Share Chart icon at the top corner of the view.
Copy the link.
Share it.
note: Only people with access permission to this view can see it using this link. You can use. to learn more about access click here.
Publishing a Chart
Once your Chart is designed and tested, publishing it involves making it accessible to audience.
to Publish a Chart:
Click Share Chart icon at the top corner of the view.
Go to publish tab.
Click Publish.
Copy the link.
Share it.
note: there are options to Restrict Access with Password, Change the Link or Unpublish the Link.
For more details, visit the public sharing article.
Field Availability & Limitations
Unavailable Fields for Both X-Axis & Y-Axis |
|
Additional X-Axis Restrictions |
|
By integrating these features, horizontal bar charts provide a structured and customizable way to visualize data, enabling users to compare values, track trends, and make data-driven decisions efficiently.








