--- schema_version: "1" id: 8e5b2f09ed5bb1f6da75a12ec9cbf5d1df210440b7e11fe065ab3b6c16e21f10 title: Bar Charts collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_chart_intro_hbar.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_chart_intro_hbar.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: a6b4c088d6d72a92e0b6a04f416f6134b5459229f0627d7bd70625a8d6c0badb description: "CRM Analytics provides the following types of bar charts: Bar, Column, Stacked Bar, and Stacked Column. Use the Bar or Column chart to provide a quick visual comparison of related values. Use the Stacked Bar or Stacked Column chart to show groups within each bar." products: - CRM Analytics - Cross Cloud release: "264" --- # Bar Charts CRM Analytics provides the following types of bar charts: Bar, Column, Stacked Bar, and Stacked Column. Use the Bar or Column chart to provide a quick visual comparison of related values. Use the Stacked Bar or Stacked Column chart to show groups within each bar. ![CRM Analytics stacked bar chart](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_stacked_bar.png) ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png) Note When visualizing large datasets in chart widgets, such as stacked charts that have narrow individual stacks, consider increasing the overall chart size. Expanding the chart can make it easier for users to select items. This also makes it easier for them to interact with and understand the detailed information in the chart. Larger charts reduce visual clutter and improve the precision of mouse-overs and clicks, ultimately leading to ‌more intuitive and satisfying interactions. ## Create a Horizontal Bar Chart Use a horizontal bar chart to compare values across one or more categories. Using the auto-fit feature, you can fit a bar chart into a crowded dashboard without the necessity of long scroll bars or loss of information. For example, create a bar chart that analyzes the average opportunity amount by opportunity owner. 1. In the lens, click ![Charts button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_chart_mode_button.png) and then select the **Bar** chart type. 2. In the Bar Length field, add one or more measures. 3. In the Bars field, add one or more dimensions to analyze the measures by. 4. To rank the records and see the highest or lowest values, click the down arrow next to the measure and sort the results. ![Analytics bar chart sorted in descending order](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/wave_charts_bar_sorted.png) 5. To change the chart display, click ![Formatting button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_button_formatting.png) and set the chart properties in the Formatting panel. For example, to show all bars without scrolling, select **Fit** in the Auto Fit field. ![bar chart with auto fit selected in dashboard designer](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/chart_bar_fit.png) ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_tip.png) Tip If you resize the bar chart while arranging a dashboard and lose the labels, choose **Preserve labels** in the Auto Fit field to restore them. ## Create a Stacked Column Chart Use a stacked column or bar chart to compare parts of a whole and show values across one or more categories. For example, create a stacked column chart that analyzes the total opportunity amount by opportunity owner and breaks down total opportunity amount by opportunity type within each bar. 1. In the lens, click ![Charts button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_chart_mode_button.png) and then select the **Stacked Column** chart type. 2. In the Bar Length field, add the Sum of Amount measure. 3. In the Bars field, add one or more dimensions to analyze the measures by. 4. To rank the records and see the highest or lowest values, click the down arrow next to the measure and sort the results. ![Analytics stacked column chart sort options.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_chart_stackedColumn_sort_order.png) 5. In the Bar Segments field, select **Stage**. Each chart bar breaks up the total amount to show the value contributed by each opportunity stage. 6. To change the chart display, click ![Formatting button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_button_formatting.png) and set the chart properties in the Formatting panel. For example, to show the total for each bar, select a value in the Show Total field. To subtract negative values from the total, select **Net**. To ignore the negative signs and add the absolute values, select **Absolute**. ![The animation shows the absolute and net totals in a stacked column chart.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_stacked_bar_show_totals.gif)