How to create an Excel "sliding" bar chart

[marcus314]

Howdy folks. I'm looking to create a sort of "sliding" bar chart in Excel. This chart will have a "whisker" that extends out to 100% and the bar chart will only fill the appropriate space among the whisker.


Could anyone help me recreate this chart in Excel?


Thanks much!


Marc

 

[oldbrewer]

A NORMAL VERTICAL BAR CHART ( or horizontal ) fills the bar according to the data value, so a 2 axis chart with second axis having a value of 100% would seem to fit your requirements - if you need the top to the whisker that can be applied manually...........

 

[marcus314]

A NORMAL VERTICAL BAR CHART ( or horizontal ) fills the bar according to the data value, so a 2 axis chart with second axis having a value of 100% would seem to fit your requirements - if you need the top to the whisker that can be applied manually...........

Thanks for the info. Though how would I get the primary axis to overlap the secondary axis?

Thanks!

 

[marcus314]

Hello everyone,

I figured it out with the help of another user. This type of formatting can be accomplished with error bars.

https://support.office.com/en-us/ar...-a-chart-e6d12c87-8533-4cd6-a3f5-864049a145f0

Thanks so much!