How do I make a chart automatically update when there is a new month?

[hmmmidk220]

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
4%	5%	4%	2%	3%	4%	5%	0%	0%	0%	0%	0%

<tbody>
</tbody>

Hi!

So I have a line chart linked to the above table. Each cell of data in the table gets it's % from the database each month. When the database is refreshed , the new month populates and the % goes from 0 to whatever it is. Each month the chart data has to be manually adjusted to look at the new month, and can't look at it all of the months because the months' without data yet (0%) will mess up the chart.

So I've seen solutions with dynamic ranges/tables and offset formula, but I'm not sure how to make it work in this case.

Also, since the % could be zero for a month that we have data for, I would at some point use an if statement to make future months (which will say 0% too) say something else such as blank, because otherwise I don't see how the chart could filter those out. Ignore this part if it doesn't make sense. How would I go about making this chart dynamic?

Thanks!

 

[mole999]

I would extend dec onwards for maybe a year, then set your chart for the full width, then hide the columns you don't want to model and it normally adjusts