Chart until blank?

[doctorteeth]

Dear all,

i have a database on excel and i would want to creat a chart that would work for this database
how ever , the data base is constantly changing and i would like a chart that would only count all the cells wich is in this database and not more and not less.

since the last cell in the row is empty , I would think there is might be a way to set the chart "Untill blank" cell in the row.

Is there any way to do so ? maybe a VBA way to do so ?

Thanks

[sweep]

Hi,

You can do this using a dynamic chart and named ranges. If you perform a forum search on these keywords all should become clear!

[doctorteeth]

Thanks!
I think i got it now