Chart to show percent of total

[Benzoli7]

Thanks for looking. I have two numbers that I want to show on the same column in a chart similar to a stacked column chart but, I can’t quite figure out how to do it.

1. The first number is a count of orders.
2. The second number is the percentage of those orders for which the optimal provider was used.

For example, if there were a total of 12 orders for a given week and 75% of those orders used the optimal provider, I would like for the column in the chart to be filled up to the 75% level with another color.

Thanks so much for your help.

 

[Robert Mika]

This is a liitle bit of manual work but it works.
Please see below and in attachment

The method is to to link number on the chart with coresponding numbers in the table.