How to create an Excel "sliding" bar chart

Have you got some actual data you could share with us so that we don't have to reinvent the wheel?

I see that you have cross-posted this on another forum: https://www.mrexcel.com/forum/excel-...bar-chart.html

Please note for the future that this forum requires you to declare and provide details of cross-posts at the outset. Please read this forum's rules.

It looks to me like a basic bar chart (which you say you can already create) with a positive error bar added to the data series. Assuming you have the data in post #3 and the basic bar chart created, I would expect to:

1) Add a column that calculates the difference between the datum and 100%. =1-B2 (assuming the data are in column B and this column is probably in column C).
2) Select the chart and the data series and add the error bars https://support.office.com/en-us/art...5-864049a145f0
3) Format the error bars so that they
3a) only show the positive error bar
3b) have a custom value for the positive error bar taken from column C.
3c) any other formats that are needed.

Does that help?