Using a cell reference as the axis value for Horizontal axis crosses

[betuttle52]

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?

 

[Andy Pope]

Hi,

A coded solution is currently the only way.

Cheers
Andy

 

[betuttle52]

Great I have 9 charts on a sheet with different values in each
horizontal access crosses at. Thanks for your response

 

[Breck]

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

 

[Andy Pope]

Hi,

I answered you by confirming VBA was the only way.
If you need actual code see Jon's page.

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

Anything else and you need to spell it out.

Cheers
Andy