Help with bar graph on Dashboard
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

Try having the names in one column and then have two other columns immediately to the right of the name column. One for Wins and one for Losses. Then your numbers would fill out the center matrix portion.

Thanks for the info. Is there any chance you could provide an example using the grid I provided? I've tried multiple variations of what I think you mean, but now i"m getting 4 bars per person (2 bars that show wins and losses, 2 bars that show the values of those wins and losses)

Thanks Paul. I do understand that, but I am also hoping that I can have the number of wins and losses labeled as well.
Here is ultimately what I'm after using my first example:

In that case you would need additional columns for Wins (A) / Losses (A) / Wins (B) / Losses (B) / etc..

@Paul Newcome Are you able to share what the source sheet would look like this for? When I add extra columns beside them, I just get more bars.

Hi @Paul Newcome  i did a bit more digging. It looks like something similar came up in the past which you replied to. I think his question was better worded than mine. It looks like this isn't possible at the moment unless something has changed ? https://community.smartsheet.com/discussion/74151/howtodisplay2datalabelsinabarchart
Help Article Resources
Categories
Check out the Formula Handbook template!