Changing series order in stacked bar chart?

I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them.

The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't understand why the chart isn't matching it. I tried switching rows and columns but that just puts the bars in the same incorrect order (1, 2, 6, 5, 4, 3).

Anyone encountered this before?

Find more posts tagged with

Sheets

Dashboards

Accepted answers

All comments

Naeem Ejaz

Working fine for me.

Yasar_smartsyncapp

Yep, this is a known Smartsheet quirk. Charts don’t respect the order of dropdown values or how the sheet is sorted. Smartsheet auto-orders the series behind the scenes (often by how the data is grouped or first encountered), and there’s no manual way to reorder status stacks in a chart. The usual workaround is to create helper columns (one per status) or a helper report that forces the order, then build the chart from that. It’s annoying, but it’s the only reliable way right now.

Paul Newcome

@nmlinac Are you able to provide a screenshot of the source data?

Paul Newcome

@Yasar_smartsyncapp Please double check your source(s). Charts do respect sort order of the data.

nmlinac

Blurring most of it for privacy but you can see the relevant columns are sorted. I've tried sorting by Status, Branch, Status then Branch, and Branch then Status but none give me the right series order

Paul Newcome

What does the data feeding the chart look like?

LesGos

I am having a similar issue/question and have not resolved it. I would like for the "Adjustments" to be on top (I am trying to make a Waterfall Chart workaround).

Here is the data:

And here is the resulting chart:

I would ideally like for the Remaining (Hidden) numbers to be on bottom, so it looks as though the adjustment is floating, similar to a waterfall chart like this:

It would be most helpful if SS had a Waterfall Chart widget, but they do not, so this is the recommended workaround. Now I need to stack the series as mentioned. How can I do this?

EDIT: Figured this out right after I posted. Moved the "Remaining (Hidden)" row up above the Adjustment rows in the data table.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.