Hello Everyone.

I am new to creating charts so this may be an easy question. I have a set of data that is populated monthly. What I want to have the chart do is ignore blank cells as well as only display the previous 3 months data. Right now I only used Jan-Mar for the source data but would like to be able to have the chart update automatically when the table is updated. Hopefully I am explaining this correctly. Data is like this:

Date Volume Variance

Jan 100,000 .44%
Feb 200,000 .32%
Mar 150,000 .33%
April
May
June
July


Thanks for any help.

Steve