Column chart vs. Stacked Column chart

Column and Stacked Column Charts are effective for visualizing data with vertical bars.

Introduction

Both Column and Stacked Column Charts are effective for visualizing data with vertical bars, but they serve slightly different purposes.

The Column Chart displays individual data series side by side, making it ideal for comparing values across different categories.

In contrast, the Stacked Column Chart shows the cumulative total of data series stacked on top of each other, which is useful for understanding the contribution of each series to the total value.

Suitable Use Cases:

  • Column Chart: Ideal for comparing individual values such as monthly sales figures for different products.

  • Stacked Column Chart: Useful for showing how different components contribute to a total over time, such as total sales with breakdowns by product 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. For example, "from table 'Order List', show the number of orders per month in 2015."

Specify the data criteria to ensure the chart reflects the desired information accurately.

Style

Customize the chart’s appearance by choosing 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 an explanation below the chart to help users identify different segments 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 line along the axis.

  • Axis Grid Line Checkbox: Decide whether to include grid lines in the inside area of the chart 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 label of the axis, 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 a line along the axis.

  • Axis Grid Line Checkbox: Choose whether to include grid lines in the inside area of the chart for better readability on value.

Series

Define each valua label of series or segment within the chart.

  • Value Format: Choose the format for the values, 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