• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    This is awesome. Thank you so much. I love how this allows for customisation and extended information. Much appreciated.
  2. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    Hi Hui, Actually it does, magnificently. I was referring to the VBA/Automated chart when I said that. Both versions are very helpful.
  3. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    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...
  4. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    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.
  5. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    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.
  6. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    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. :)
  7. Varna

    Creating a Combined Cluster-Stacked Chart (with multiple series) in Excel

    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...
Back
Top