Excel Chart - stacked column to chart progress

[kschreib]

I have been asked to create a chart that will chart progress for product sales against a specific target and we would like to know which sales channels the sales are coming from. This is mostly supposed to be an easy visual aid for a quick view of the progress. I am thinking that the thermometer type charts would be a good starting point, but I don't know if it's possible to use a stacked column in place of the typical column in the thermometer charts to show overall progress, but also the makeup of the sales by sales channels. This is a relatively short term project and I'd like to be able to use just one bar and update it every few weeks. Any suggestions? Thanks!

 

[kschreib]

Thank you both for your help. This is exactly what I was looking for.