If data present, then display graph.

  • Thread starter Thread starter Solomon
  • Start date Start date
S

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?
 
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
 
Back
Top