I am working on creating a dashboard template in excel for our business program reporting and am running into a small frustration. We can have anywhere from 3-7 metrics, and I am building a relational workbook that updates multiple sheets based on input on one sheet. When I am making charts I am setting them up for the 7 rows that could be filled with metrics, but when there are <7 metrics, the chart has multiple blank areas on the X axis.

Is there a way to make the number of items on the x axis conditional based upon something being entered in the cell? Does this make sense?