I need to plot a dynamic bar graph in Excel that contains three identical bars where I can modify the width of the bars and the distance between them. Additionally, I want to repeat the same three bars again after a specified distance between the two sets, as shown in the picture below.
I want to be able to set the width of the bars, the distance between the bars, and the distance between the two sets from cell values so that I can easily modify them.
How can I achieve this in Excel?
Thank you!
enter image description here
I tried to do it by my self on excel but I don’t get the expected results
enter image description here
Younes DOUAMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.