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?

Hi,

You can create a dynamic graph based on defined names.

http://peltiertech.com/Excel/Charts/DynamicColumnChart1

Or search on google

Winnie



"Solomon" wrote:

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?

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?