Can I create a chart in a dashboard from multiple cells that are not next to each other in a sheet?

Hello,

I am brand new to Smartsheet and this form. I have tried to search answers to my question but didn't find it. I am trying to create a bar chart in a dashboard using cells that are not next to each other. Is there anyway I can create a bar chart from, for example, row 1, 2, 3, 6, 9, 12 and col 1, 2, 3, 4, 5, 6....

Find more posts tagged with

Accepted answers

Kimberly Loveless

Unfortunately the data for creating charts in a dashboard must be in consecutive columns and rows.

I would suggest putting in an enhancement request as I know that you are not the only one looking for this functionality

All comments

Kimberly Loveless

Unfortunately the data for creating charts in a dashboard must be in consecutive columns and rows.

I would suggest putting in an enhancement request as I know that you are not the only one looking for this functionality

Jing Wang

Thank you so much, Kimberly. I will put in an enhancement request

Andrée Starå

Hi @Jing Wang

I hope you're well and safe!

Are the cells on the same row?

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jing Wang

Hello Andree,

Thank you. Hope you are well too.

Not all cells are in the same row. Is there anyway I can "add" data to existing bar chart?

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.