Help with bar graph on Dashboard

Options
Dan Tanner
Dan Tanner ✭✭✭✭
edited 11/01/23 in Formulas and Functions

Hi everyone,

Hoping to get some help on a bar graph that is racking my brain a bit. I've made a sample of info i'm trying to chart:



What I am hoping to do is:


Have Joe and Dan on the X axis

Both Joe and Dan have two separate bars, one for win, one for loss, and have total number of "wins" and "losses" on the Y Axis

Have the total value listed inside of the bar.

As an example, for Joe, I would like a bar showing total number of wins being 4 and a total of $2000, and a bar beside it showing total number of losses 2 and total of $400.

A stacked bar graph would could work if that's the only way to do this.

I should note, that in my real life application, there are 7 different employees, and 4 different statuses. Not sure if this makes a big difference, but wanted to make my sample digestible.

I'm comfortable with helper sheets and IF statement formulas (sums, counts etc), just having a hard time piecing it all together.

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!