A **vertical 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 ![](https://app.chatwoot.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBCRHplekFVPSIsImV4cCI6bnVsbCwicHVyIjoiYmxvYl9pZCJ9fQ==--fa7f13c38a219653c35b7e8e31e9a62961794953/create-2Bnew-2Bbar-2Bchart.gif?cw_image_width=1800px) \ to add a new chart: 1. Within the table, click on the "+" sign above the search bar. 2. From the drop-down menu, select **Chart view**. 3. A box will appear to enter a name for the view—choose a **descriptive name** that reflects its content. 4. **Select who can edit:** * **Collaborative** for team access and editing. * **Personal** for individual use. **note: you can't add it in dashboards** 5. Click "Add". 6. Click Chart type . 7. 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: 1. **Remove the breakdown** (if previously applied) to allow a side-by-side comparison. 2. **From the y-axis dropdown list, choose "Estimated Income"** as the second measure. 3. **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. 1. A box will appear; click on **"Add filter."** 2. 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: 1. Click **Share Chart icon** at the top corner of the view. 2. **Copy** the link. 3. 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](https://chatwoot.help/hc/datalexinghelp/articles/1783284028-permission-overview). --- # **Field Availability & Limitations** ## **Unavailable Fields for Both X-Axis & Y-Axis** * Long text * File * Multiple select * Collaborator * Link to table * Lookup * Formula containing lookup output * AI * Formula containing AI output ## **Additional X-Axis Restrictions** * Number * Rating * Count 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**.