help building chart for dashboard

Hi everyone, hoping for a little help here,

I recently did a survey of 240 employees with 9 yes or no questions. I am hoping to create either a linebar or stacked linebar graph showing the 9 questions in a single chart with the question being on the left axis.

When I try to do a report to create this graph, Im unable to figure out a way to do this with group.

My columns are check boxes but I could change them to "yes" and "no" if that makes any difference.

I feel like this shouldn't be hard at all. Can anyone step by step this for me?

What i'm hoping for, where the green line indicates how many answered yes:

Find more posts tagged with

Accepted answers

All comments

jjg279

Hey @Dan Tanner , I suspect there are a lot of ways to go about this. One would be to make an entirely separate sheet with your summary data and graph that. Or you could add a row at the top of your columns for your summary info. Here is what I did (you have to make the column text instead of a checkbox and "true" = checked):

Then went to my dashboard and added a chart and selected that top row as my data source:

Could do the same gathering on a separate sheet as well.

Dan Tanner

@jjg279 - Thank you. My HOPE is actually to have a scenario where the false (in your case) is also accounted for.

So, in your scenario, if 20 people are asked the question, the bottom axis would go up to 20, but chart that 12 people answered "true". There is no question where 100% answered true so that's not an option either…

Hope this makes sense…

jjg279

Hey @Dan Tanner , it does. Smartsheet charts have some limitations for what you are talking about. I have found a coupe work-arounds, but they aren't perfect. Here are the two I would recommend/use most (for 50 respondents):

The one on the left is a stacked bar chart where you would also calculate the number of "false" and use that as a data source. Then make the "No" columns white. I did create a separate sheet for that one.

Same formula as above, just referenced the original sheet.

The graph on the left has an additional column on the original sheet titled "." which totals all values in any question column. You then make this column white.

There are drawbacks to both methods; and I haven't found a better way, but maybe someone else has…

Dan Tanner

Right on. Appreciate the help.

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.