Hi all,
I'm analyzing some data where I'm basically interested in seeing the distribution of some data in the best possible way.
I'm looking at two values, High & Low, of which the sum of the two always is 100 % or 1, so basically looking at the ratio of the two. Both High and Low are calculated as the percentage of the Range (column B).
For example, if High = 0,1 then Low = 0,90 and vice versa.
I created three charts in columns M to T. Please see attached workbook. The upper two contains data, but the lower one basically just illustrates the 'ratio' graphically.
This kind of does the trick, but I was wondering perhaps if these three charts could be combined into one? Maybe a % count of ratio on the bottom chart?
I'm not too savvy with all of this and combining charts (adding series, etc.), so would be great if anyone had any suggestions.
Thanks in advance for any help!
Best regards.
Elijah
Bookmarks