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

Jing Wang

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....

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

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?