I know that it has been only three days since I posted this but any takers
on answering this.

wrote in message
...
Is there any way of referencing a cell as the value in the "axis
value" area of the "Format Axis dialog box. I am currently entering a
number i.e. 2.5. I would like to be able to have this number change
when a user enterer a value in a cell? Would it have to be VBA code
or is there another way?