First approach would be to summarize your data with a pivot chart:
- select your data, then go to Insert - PivotTable - PivotChart
- set:
- major category to
column labels
- computerisation to
row labels
- employment to
values
(calculate it's average)
- change chart type to stacked area
Depending on size of your data and accuracy (number of decimals) of computerisation data, this could give you a nice chart.
For me, on 100 completely random data, with 3 digit accuracy of computerisation it isn't really nice:
Next step is to group (bin) your data
You need to group data in order to get enough amount of information in each group to show a realistic chart (e.g. group together companies with computerisation 0.015 - 0.025).
As probability is going from 0 to 1, a very easy grouping is just to round them, entering a new column, you can round to
- 3 decimals with
=ROUND([computerisation],3)
- 2 decimals ending to 0 or 5 (0, 0.05, 0.10, 0.15...) with
=ROUND([computerisation]/5,2)*5
Using the second grouping I could achieve a more nice chart:
Number of groups is really depends on your data (number records, distribution across bins, groups, company sizes), probably you need to play a bit around to see what gives the best picture.