Excel Charts, how to auto select ranges

I have a table that is filled by a query from the DB, it returns from 10 to 15 rows.
how can I create a chart that will handle the number of rows dynamically without the user having to define the range of values and lables ?