Dynamic chart only filling half the plot area

[zephyrunimpressively]

Hello!

Hoping there’s a simple answer to this. I’ve made a dynamic column chart using named ranges and a dropdown that controls the chart. It’s working fine except the chart doesn’t take up the entire plot area and it’s making the x-axis labels unreadable.

The chart was created using named ranges -

Series name: =Sheet1!$E$1

Series values: =Test.xlsx!ChartValues

Axis label range: =Test.xlsx!ChartLabels

The formula for ChartValues in Name Manager is -

=Sheet1!$E$2:INDEX(Sheet1!$E$2:$E$15,COUNTIF(Sheet1!$E$2:$E$15,”<>#N/A”))

The formula for ChartLabels in Name Manager is -

=Sheet1!$D$2:INDEX(Sheet1!$D$2:$D$15,COUNTIF(Sheet1!$D$2:$D$15,”<>#N/A”))

Like I said it’s updating as it should be it’s just only taking up part of the plot area when the data in the named range from the dropdown is, for example, 4 cells rather than all the cells.

Is there any way to rectify this?

Thanks!