-
1. Re: Stacked bar question
Vincent Baumel May 22, 2017 12:56 PM (in response to Laurie Miles)This data source is protected by your specific Google Sheets login. Could you repackage the workbook as a .twbx and attach that? My understanding is that your stacked bar chart with table calc labels is actually pretty straightforward to do, I just want to make sure that everything plays nicely with your data :-)
-
2. Re: Stacked bar question
Jim DehnerMay 22, 2017 1:12 PM (in response to Laurie Miles)
Hi Laurie
see the attached
This is a dual axis chart --see the link Dual Axes
Please let me know if you have questions
Let me know if this helped
Jim
-
dual bar for Laurie.twbx 60.6 KB
-
-
3. Re: Stacked bar question
Laurie Miles May 22, 2017 1:14 PM (in response to Vincent Baumel)Hi Vincent.
I've changed my Google sheet's visibility. Would you please look at the .twbx when you get an opportunity.
Thank you.
-
4. Re: Stacked bar question
Vincent Baumel May 22, 2017 2:00 PM (in response to Laurie Miles)Okay, there's a couple things I'm noticing. First, the percentages you're after are all within a pretty small percentage:
That being said, I'm not sure a stacked bar is the way to go here, since a bar representing 1% isn't really going to appear that much different than a bar representing 2% even though it represents quite a BIG difference. Doing a true dual axis would me misleading in this case, since one bar would represent a percentage and the other would represent a population sum. The way to mitigate this would be to even out one of the measurements. Here's one idea:
What I did here was dual axis a total population graph (% of total, running across the table so that every location shows 100%) and a population of those lacking literacy. I set this second axis to a Gantt bar, and labeled it with a table calculation based on % of total. This way, you're highlighting the important story you're trying to tell. Doing this as a dual axis of population against population would have a bunch of tiny portions and a bunch of big portions. This would only serve to minimize the impact of what you're trying to show.
Like I said, this is just one idea. I'll attach a packaged workbook so that you can reverse engineer the table calculations. Let me know if this helps!
-
NC literacy for Laurie.twbx 29.7 KB
-