Thank you. The information i.e. trend I would like to be able to see is how the percentage (proportion of poor & rich) changes from each year to the next (i.e. 199 to 2005), within each block of Class 1, Class 2 and Class 3. Perhaps a trend-line or a line graph (using some kind of combination...
This is very cool. Wow. :) The values around the bars are years - 1999 on the left and 2005 on the right. The way I would read the chart would be to see a trend from left to right i.e. the change in percentage of poor or rich from 1999 to 2005.
Thank you for the warm welcome! I agree with you about the simplification. And thank you for showing me how to make the same chart in excel, that is some really clever formatting.
Thank you for the warm welcome. I came up with something similar too and yes that is a much cleaner way to display a complex table! I have a lot to learn, thank you. :)
Hi,
I'm trying to see if it is possible to create a stacked-cluster chart with multiple series in excel. From what I have looked up, doing this natively isn't possible and the closest I have got is to use a stacked area chart. My data is in the attached file (example data) and 1 or two possible...