Chart of duration by reason containing count

[edan]

Hi all,
Ill explain: I have a set of tools and they are not working for some reason:


I want to create one chart that tells me for what reason("Drill Down", and "root cause") those events happens, which entity, for how long, and how many times those events happen.
something like this:


those numbers are how many times the event occurs (did it in paint).

So, the QUESTION is:
1. how do i do the thing i did in paint?
2. do you have any suggestion/idea to make this chart better to read?

Thank you very much!
Edan

 

[Hui]

Edan

Firstly, Welcome to the Chandoo.org Forums

Can you please post a sample file of data as it makes solving issues a lot easier.

 

[edan]

Here is the file

 

[bobhc]

You may find help here as it is a question with similar problems.

http://chandoo.org/forum/threads/sumif-is-such-a-hog.19848/


.

 

[edan]

bobhc, thank you, but it is not at all the case.
i want to have the same chart i showed - with the number of times (count) it happen (probably best way to show it is inside the bar).
as example i painted in paint

 

[Hui]

Right Click on each series in the Chart and select Add Data Label
It should default to the Count

Select any of the Labels that show 0
Right Click, Format Data Labels
Goto the Number Format
Untick Linked to source
Add a Number Format of #;-#;;



See attached file:

 

[Faseeh]

I uploaded this file to a wrong thread. you can use pivot table as well.

 

[edan]

Thank you for your quick reply.
I managed to do that only with clicking each entity, isn't there something that do it to all in one click?
but i meant to combine those 2 charts:


this is for SUM of duration.


this is for COUNT of duration.

i thought to use the first chart (SUM) but the numbers inside will be of the second (COUNT).
do you know how to do it?
or do you have any idea to do it somehow different?

Thanks again!
Edan

 

[Faseeh]

@edan

Please see attachment does it work. (requires manual work)

 

[edan]

Thanks again,
but I didn't get what you did, and the data is not accurate..

 

[Hui]

Because you haven't given us the whole file and the data is locked due to the break away from the Pivot Tables/charts source, it is hard to assist much further.

But the techniques I described above should still be valid