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

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.

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

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"* B e X *" <* B e X wrote in message
...
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.