Bar chart vs. Stacked bar chart

Bar Charts and Stacked Bar Charts are both useful for comparing data across categories using horizontal bars.

Introduction

The Bar Chart displays individual data series side by side, making it ideal for direct comparisons between categories.

In contrast, the Stacked Bar Chart shows the cumulative total of multiple data series stacked within each bar, which is useful for understanding how each segment contributes to the overall total.

Suitable Use Cases:

  • Bar Chart: Ideal for comparing values such as sales performance across different regions.

  • Stacked Bar Chart: Useful for showing the breakdown of total values across categories, such as total revenue with contributions from different product lines.

Notes for Specific Types:

  • Bar Chart: Typically used when comparing discrete categories side by side.

  • Stacked Bar Chart: Used when you want to show the total amount and how different segments contribute to this total within each category.

Settings

Title

Provides a clear label for the chart, helping users understand what data is being visualized.

Caption

Offers additional context or explanation for the chart. It may include data source information or key insights.

Data

Defines the source and specifics of the data used for the chart.

Specify the data criteria to ensure the chart accurately reflects the desired information, using human language with straight expression.

Style

Customize the chart’s appearance by selecting colors and whether to display a legend.

  • Color: Select colors for the bars or segments to differentiate between data series or to match your branding.

  • Checkbox Legend: Decide whether to include a legend to help users identify different series in the chart.

X Axis

Configure the horizontal axis to represent categories or time periods.

  • Axis Name: Label the axis to indicate what it represents

  • Axis Line Checkbox: Choose whether to display a the most bottom line as the main line along the axis.

  • Axis Grid Line Checkbox: Decide whether to include grid lines for easier reading of values.

Y Axis

Set up the vertical axis to display the value or measurement.

  • Axis Name: Label the axis to specify what the values represent

  • Value Format: Choose how to format the values, such as Number, Currency, or Fraction.

  • Value Label Prefix: Add text before the value in the label, if necessary (e.g., "$" for currency).

  • Value Label Suffix: Add text after the value in the label, if necessary (e.g., "%" for percentages).

  • Axis Line Checkbox: Decide whether to display the first line to the left of the chart as the main line along the axis.

  • Axis Grid Line Checkbox: Choose whether to include grid lines for better readability.

Series

Define each data series or segment within the chart.

  • Value Format: Choose the format for the values in each series, such as Number, Currency, or Fraction.

  • Value Label Prefix: Add text before the value in the label, if necessary.

  • Value Label Suffix: Add text after the value in the label, if necessary.

Visibility

Control the chart’s visibility based on specific conditions.

  • Yes: Hide the chart.

  • No: Show the chart.

  • Use PowerFX: Set conditions to dynamically show or hide the chart based on criteria or user inputs.

Last updated