| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
link chart axis scale to spreadsheet cell value
Hello,
I have a simple column chart. I would like to be able to set the maximum & minimum values of the horizontal axis according to numeric values in 2 of the spreadsheet cells. I cant see a way of doing this. Is there a trick ? Thanks KK |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
link chart axis scale to spreadsheet cell value
Hi,
There is no trick. It required VBA code to do it. http://peltiertech.com/Excel/Charts/...nkToSheet.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "KRK" wrote in message ... Hello, I have a simple column chart. I would like to be able to set the maximum & minimum values of the horizontal axis according to numeric values in 2 of the spreadsheet cells. I cant see a way of doing this. Is there a trick ? Thanks KK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to force chart axis to same scale | Excel Discussion (Misc queries) | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| How do I link Excel chart axis scale settings to cells? | Charts and Charting in Excel | |||
| Link a cell to min & max box for Value (X) axis scale? | Charts and Charting in Excel | |||
| How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
Linear Mode
