Stacked Bar Charts from Multiple Columns

I found another idea from about 2 years ago that hadn't been updated, so I figured I would ask if this is already on the radar/roadmap.

I would like to have the ability to use a stacked bar chart on my dashboard to show projects by Department and by Status. Here's an example I mocked up in Excel to show kind of what I'm looking for:

When I tried to show the same data in a Smartsheet dashboard, it just stacks "Stage" on top of the Department count, but it's just a total of how many have a Stage set, not a count of how may are in each stage. This chart is the same data as in Excel, but Smartsheet just doubles the projects - it counts 4 in Construction plus 4 that have a stage.

Find more posts tagged with

Dashboards

functionality

charts

Accepted answers

All comments

SueinSpain

Do you mean something like this

and the 2 groups

then I use this report as the data source for my chart switching on the column names and first column options so I only get the fields I want stacked

I have done something similar with this report on the dashboard too

I tended to use different reports for each chart to try to keep it simple and played around with the groups, summaries and then those options in the chart widget to get what I want

Hope this helps

Iowa.KatelynH

Ok. You have yours laid out a bit different from mine. I see that you have your stages (New, In Progress, Finished) as columns on their own. Are you using a sheet summary as the base for the report? Or do you just have those as columns (with checkboxes?) in your underlying sheet?

This is what my summaries currently count, with the same fields used for groups:

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.