If data present, then display graph.

[Solomon]

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?

 

[winnie123]

Hi,

You can create a dynamic graph based on defined names.

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

Or search on google

Winnie

 

[Ashish Mathur]

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