Excel Charts

I want to chart selected values from a worksheet. Column A contains dates and let’s say Column B contains the values. I want to create a chart that sees the last date entered and then charts the values from the previous 30 days up to that date. How can this be done?