Stacked Bar Chart

Question

Hello, Team.&nbsp; It's been a minute.&nbsp; Thank you for all the help the last two months.&nbsp; Need help with a stacked bar chart.
It currently shows like this...

I need it to reflect the % of the year, not the series.&nbsp; Like this...

------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

miketamoush · Answer

There should be a checkbox for 'Data Labels Always Visible'. Once that is checked, you should be able to check Percent of Series.

------------------------------
Mike Tamoush
------------------------------

tonygonzalez · Answer

That option is checked (the values are displayed). And "percent of series" is checked. But again, that is the root of the problem. I don't want it to be a Percent of Series. I want it to be a percent of the year. (Not the years.) i.e. In a given year, if we collect $500,000 of River Fees. I want to show the City collected 30% of that and Outfitters collected 70% of that $500K, as an example.

------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

miketamoush · Answer

Sorry, I didn't zoom in on your top picture and made an assumption the top picture was values. Let me think about your ask.

------------------------------
Mike Tamoush
------------------------------

tonygonzalez · Answer

No worries, Mike.&nbsp; But, I just got it solved.&nbsp; I think I knew this last night, it was just a long day and I needed to go home.&nbsp; Your reply prompted me to get back to this.&nbsp; I created some summary variables and the corresponding formulas.&nbsp;&nbsp;

------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

miketamoush · Answer

I think this will work, but I'll be honest - I feel like I am over complicating it, and there is a better solution. However, try this:Make Two Summary Variables:
Variable 1: Percent of Total City = City/(Outfitters +City)Variable 2: Percent of Total Outfitters = Outfitters(Outfitters + City)
When you select what to show on your chart, select the two summary variables.
Finally, use value instead of percent to display.
------------------------------Mike Tamoush------------------------------

Forum Discussion

Stacked Bar Chart