Say I have a chart display Cells A1:A12 and B1:B12, for each month.

Can I set the chart to display only the cells with values?


For instance, in March, I would only want A1:A3 and B1:B3 displayed. In June, A1:A6 and B1:B6 displayed, and so on.


Trying to avoid showing a bunch of zeros that will invalidate my trend line. Thanks guys!