Requesting (kindly) suggestions on charting 'paired' data (current solution included)?

[Elijah]

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

[protonLeah]

Option: add a column for absolute val of LOW data.
Stacked bar chart using table columns A_high & new ABS_low column.

[Elijah]

Hi, protonLeah,

That looks pretty good for the 'last 12 days'. Thanks!

Additionally, though, I would have loved if I could have somehow turned those three charts to the right of the one you created into one somehow. The ones for the entire sample.

The IDEAL, I think, would have been if I could have used the bars at the bottom chart to show the ratio visually and then have the percentage count/distribution as on the top chart.

Or the bottom chart with percentages from the top chart.

Chart.png

Or maybe the way it's set up already is sufficient and the best choice for displaying this data. It's not superimportant for me, but I figured I could ask if anyone had any ideas for improvement.

Best regards.

[protonLeah]

Add two new columns to calculate the frequency/count of each % group/range:
I3, K3:

Please Login or Register  to view this content.

[Elijah]

That's certainly an improvement, protonLeah! Thanks a lot!