Dynamic Charting

Hello, am trying to set up an automated report that includes a dynamic chart, where depending on the population, could include anywhere from 3 to 7 columns. I believe there is a way to create this dynamic set up within the Name Manager, in conjunction with the Series Values, but I always need help with the formulas in defining the names and series values, so that the blank columns are not included within the chart.

In the attached, there are three possible chart scenarios, of which scenario 2 is used, and the chart set up would dictate not including columns E-H so as to not take up real estate within the chart.

Appreciate any assistance, thanks as always!

Sheryl