Hello!

I'm trying to create a bar graph using Macros, but the data range varies.

For example

The spreadsheet may have
Date     Quantity
2/2/09      6
2/3/09      12
2/4/09      44

or it may have 
Date     Quantity
2/2/09      6
2/3/09      12
2/4/09      44
2/5/09      6
2/6/09      13
2/7/09      45
2/8/09      67
2/9/09      12

The data will be in the same columns. I just don't know how many rows of data there will be to set static values for the data range.

Thank you for any help