Hi,

Select the range (including the header row) and convert it to a List/Table
in Excel 2007 - Ctrl+L. When you convert a range to a Table, it becomes
auto expanding

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Solomon" wrote in message
...
Is it possible for one to display graphs based on whether data is present
in
particular cells?

For instance, I wish to display the information of cells A1 to A8. A9 is
blank.
I create a graph to reflect the information of cells A1 to A8.
I now fill in information in cell A9.
I now wish to display the information of cells A1 to A9.

Is it possible for me to create a formula for the graph
to automatically represent data from cell A9 when data is present
and automatically exclude it when data is not present?