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

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?

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

Hi,

A coded solution is currently the only way.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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?

Using a cell reference as the axis value for Horizontal axiscrosses
 

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


On Jan 23, 3:40 am, "Andy Pope" wrote:
Hi,

A coded solution is currently the only way.

Cheers
Andy

--

Andy Pope, Microsoft MVP - 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?

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

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?

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

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/...nkToSheet.html

Anything else and you need to spell it out.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Breck" wrote in message
...
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?