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

  • Thread starter Thread starter betuttle52
  • Start date Start date
B

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?
 
Great I have 9 charts on a sheet with different values in each
horizontal access crosses at. Thanks for your response
 
I know that it has been only three days since I posted this but any takers
on answering this.
 
Back
Top