Dynamic range for graphs?

[OldManExcellor]

I want a bar graph to display values from a column. I want all values in the column to be displayed. But the number of rows changes at times.

When the number of rows become more or fewer I want the graph to still display the rows with values and no other values.

Is this possible to achieve?

 

[gehusi]

http://office.microsoft.com/en-us/e...eate-dynamic-charts-in-excel-HA001109801.aspx