I'm going crazy... I have been looking for hours but didn't find any solution.

So, I have a very simple XY data graphic which is viewable as a bar chart.

X-axis are numbers in this structure: =SUM(B1135:B1146)
Y-axis are months

All my future months are now plotted as zero as there is no data yet, and I don't want to make a news graph every month.

Can anyone help me how to make sure the zero's of data that will still come are NOT viewable? Of course it must be possible to add data in the future, so the graphic becomes bigger automaticaly.

Thanks
Joske