Hello,
My Excel VBA macro has a random behaviour in the generation of stacked histograms.
Here is my set of data:
Quarter 1w 2w 3w 4w >4w
16Q4 100.00% 0.00% 0.00% 0.00% 0.00%
17Q1 33.33% 0.00% 0.00% 0.00% 66.67%
17Q2 10.87% 6.52% 13.04% 2.17% 67.39%
17Q3 10.00% 16.67% 13.33% 6.67% 53.33%
17Q4 28.13% 6.25% 15.63% 3.13% 46.88%
18Q1 17.86% 0 14.29% 7.14% 60.71%
The goal is to have for each quarter, a histogram showing how many times we have 1w, 2w, 3w, 4w, >4w.
The result is 9 times out of 10 an ugly graph where x and y do not correspond to what I gave, and a number of series greater than 5.
Here is my code:
Can you please help as this is getting extremely frustrating?Please Login or Register to view this content.
Thx in advance!
Regards,
Dassadar
Bookmarks