How to create a stacked bar chart with Widgets

Justin G

Hello,

I'm trying to create a stacked bar chart with the below data. Is there a way to show the below % completed without expanding all and incorporating the lines collapsed? I want to see just what is highlighted below on a stacked bar chart. Any help is appreciated!

Scott Orsey

HI @Justin G , I believe you would like a stacked bar chart with just three values in it representing the parent rows, correct? I don't think there is a way to show just those three parent rows in a chart without doing a little bit more work. You will need either to create a report that only pulls those rows in or create another sheet with cross sheet references to pull in the data into a three row table. Then you would build the chart off the newly created info.

Which option you chose will depend a bit on what you are trying to do. If this is just a one-and-done type of thing, then the report is definitely easiest. If you anticipate creating many "summary" charts, you can still do this with reports, or you may prefer a single summary sheet where you make a bunch of smaller tables that you use for charting and dashboards.

I hope this helps.

Be well

Scott Orsey

HI @Justin G , I believe you would like a stacked bar chart with just three values in it representing the parent rows, correct? I don't think there is a way to show just those three parent rows in a chart without doing a little bit more work. You will need either to create a report that only pulls those rows in or create another sheet with cross sheet references to pull in the data into a three row table. Then you would build the chart off the newly created info.

Which option you chose will depend a bit on what you are trying to do. If this is just a one-and-done type of thing, then the report is definitely easiest. If you anticipate creating many "summary" charts, you can still do this with reports, or you may prefer a single summary sheet where you make a bunch of smaller tables that you use for charting and dashboards.

I hope this helps.

Be well

Justin G

Ahh yes, that's what I was kind of thinking but wasn't sure. Thanks for the help here!