• 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.

Waterfall chart with multiple dimensions

srini1912durai

New Member
I am looking to generate a waterfall chart with these parameters built in:

I want to see the count of issues as on a certain date categorized by "Identified by" & also categorized by "Severity". So if I select Jan 1st as the date, the 1st stacked bar will be by "Identified by" & 2nd stacked bar will show the same number of issues categorized by "Severity". 1st & 2nd stacked bars will be presented without any gap as they are indicating the count of issues as on Jan 1st.

The end date is say March 15th.

Some new issues added, some issues reopened & some issues have been completed/removed between Jan 1st & 15th March.

So in waterfall chart, the 2nd set of stacked bars will be for new issues again 1st stacked bar by "identified by" category and 2nd stacked bar by "Severity".

Same case for reopened, completed & finally for issues as on 15th March.


The problem that I am facing is that the dimensions are multiple unlike the simple waterfall chart. Please suggest.
 
Hi Srini1912durai,


Welcome to the forums, can you upload some sample data?? meanwhile you can find this useful:


http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/


Regards,
 
Back
Top