Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
Value (Y) axis crosses between categories and Secondary Value (Y) Axis | Charts and Charting in Excel | |||
How do I force a secondary horizontal axis to act as a date axis? | Charts and Charting in Excel | |||
Value (Y) axis crosses between dates | Charts and Charting in Excel | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel |