In charts, is it possible to change data references to relevant?

[* B e X *]

Ive created a basic bar chart, but the speadsheet in which the data is held
is constantly being updated. This is ruining my graph as the data references
are absolute. Is there a way of changing the source data references to
relevant? ive tried "f4" when in the graph "Source data", "values" option,
but this does not work.
Ive tried deleting all of the $ from the data, but they apear again when the
dialogue box is closed.

 

[Jon Peltier]

Charts use absolute references. But you can also use a reference to a
dynamic name:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon