Stacked Bar Chart show totals at the top?

Greetings, I am creating a stacked bar chart showing hrs spent by category. Is there a way I can show the total hrs in large font at the top of each column?

Right now my graph is driven by a report off of the table data without an groups or summaries.

I'd really love for this to be an area chart, but couldn't find any way to do that in Smartsheet.

Sincerely,

Find more posts tagged with

Accepted answers

Georgie

Hi @mela0645,

I’ve tested this on my end and confirmed that @Naeem Ejaz’s suggestion of adding a totals column to the sheet would be one way of doing this, but the data is added as another section of each stacked column, rather than showing in large font above the columns (as seen below):

AD_4nXe9tIWdeXZRJsrf3lLxa9C8OPiwftYYyEzwWmEZbUnioWfMJdUllMgkmE-K3XlfLZCmsxAFSlW9GvofrUkmKCGnrJQUXNqVWEANzTN4OIPkL93Qew4dQxQz0xwkmLoPPIYfN9lcyA?key=ayxBZyuztt4suu4Ek1tBfw

I also tested different combinations of grouping and summaries in a report created from the sheet but found no way to show the totals above the columns in the chart.

When you have a moment, please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

Thanks,

Georgie

All comments

Naeem Ejaz

In your source sheet/report, add a helper column that calculates the total hours for each category.

Georgie

Hi @mela0645,

I also tested different combinations of grouping and summaries in a report created from the sheet but found no way to show the totals above the columns in the chart.

Thanks,

Georgie

mela0645

Thanks Georgia for trying this out. I was afraid there wasn't a solution. I followed the link you provided and submitted product feedback.

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