Ben, I copy an answer to a similar post below:
You can set up your actual data as a dynamic named range series, using the
OFFSET function. Many MVPs give tutorials how to do this on their websites,
see for instance:
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/e...ps.htm#Dynamic
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.contextures.com/xlNames02.html

GL,
Henk

"Ben M" wrote:

Hi, I have a situation where I have a spreadsheet with 2 columns, A and B.
Column A is the date and Column B is the # of bids we have submitted on that
day.

I create a graph based on those columns, that shows the date on the X-axis
and the # on the Y-axis.

But I would like the graph to be updated automatically everytime I add a new
row to the spreadsheet. So that tomorrow, when I add the row for May 10, the
chart will reflect May 10 without requiring me to recreate the chart.

Is this possible? I've tried everything I can think of and it hasn't worked.

Thanks!
Ben