Question re: automating graphs to shrink in size

Hi all,

I'm new to this forum.

My work has recently requested that I automate a process on Excel and was wondering if you all had any advice. Specifically, I work for a solar company and am creating an electrical design in Excel. As it stands I have a certain number of "solar panels" with an interactive entry cell on the left where I can determine the number of panels that should be available for viewing. However, I've coded this so that the design fills a bar graph and therefore, if there are only one or two panels in a line, they fill the bar graph and become extremely stretched and unreadable.

Snip.jpg

So my three questions are:

1) Is there a way to make the number of panels I want automated while not inserting into a bar graph?
2) If so, is there a way to do this while keeping the original size of the panels so that they simply cut off at the end rather than stretching and becoming unreadable?

Any suggestions would be really appreciated.