How to automate data range on excel chart?

Im trying to create a worksheet in excel 2000 to process and graph data. The data is stored in columns and is of variable length in each run. To automate the plotting of the data, in the series I need to set the range to $B$2: (last cell that contains a value). How do I specify the last cell that contains a value without having to select it manually?





Thanks much!How to automate data range on excel chart?
When creating a Chart, there is problem with specifying a larger area of cells than there exists data. You could end up with a large portion of the graphed data being blank (the cells with no data).





You could have a single ';dummy'; row at the very end of your data, which is part of the Chart you created. Any new rows of data that you add in would be inserted above that ';dummy'; row, and the Chart would adjust automatically without having to modify the Data Range within the Source Data area.