Skip to main content
Question

Stacked Bar Chart

  • July 14, 2025
  • 1 reply
  • 51 views
louis.forst11
Level 2
Forum|alt.badge.img

Hi, i have a Bar chart with the time axis on the x-axis and on the y axis how much the money was. Is there a way to break down the y axis graph into the specific vendor_names, there are around ten. 

How could i do it in a view.  Thanks in advance

    1 reply

    N
    Celonaut
    Forum|alt.badge.img+2
    • Navya K
    • Celonaut
    • 26 replies
    • July 15, 2025

    Hi Louis,

    You can do this by adding vendor_name as a dimension to your chart. Here's how you'd set it up in a Celonis View:

    1. Select your Bar Chart: Ensure your existing bar chart is selected in your Celonis View.

    2. Add vendor_name to Dimensions:

      • Go to the chart's configuration panel (usually on the right side).

      • Find the section for Dimensions (or "Breakdown" / "Group By").

      • Drag and drop or select your vendor_name column (e.g., "TABLE_NAME"."VENDOR_NAME") into this dimension slot.

    3. Adjust the Y-axis (Value) Aggregation:

      • Keep your current Y-axis aggregation (e.g., SUM("AMOUNT_COLUMN")). The chart will now automatically calculate this sum per vendor_name for each point on your time axis.

    4. Choose a Stacking Option:

      • In the chart configuration, look for "Stacking" or "Display Options."

      • You'll likely want to select "Stacked" or "Stacked (Percentage)".

        • Stacked: Shows the total money on the Y-axis, with each bar segment representing a different vendor_name's contribution. This is great for seeing both the total over time and individual vendor contributions.

        • Stacked (Percentage): Shows each bar as 100%, with segments representing each vendor_name's percentage of the total for that specific time period….Hope it helps, thank you

     


    Community Code of ConductAccessibility statement