Stacked Bar Chart
Hello, Team. It's been a minute. Thank you for all the help the last two months. Need help with a stacked bar chart.
It currently shows like this...
I need it to reflect the % of the...
Forum Discussion
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
------------------------------
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
------------------------------
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
------------------------------No worries, Mike. But, I just got it solved. I think I knew this last night, it was just a long day and I needed to go home. Your reply prompted me to get back to this. I created some summary variables and the corresponding formulas.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------Hah, I posted 30 seconds after you. Looks like we came up with the same solution.
------------------------------
Mike Tamoush
------------------------------
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
------------------------------