D
djzabala
Hello Everyone. I have some sort of a problem with linking chart axe
(min and max values) to cell values in a worksheet. I am using th
macro that I found in Mr Peltier' site:
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
It worked just fine for a simple test I was doing.. BUT, I came up wit
the idea of assigning to the cells (the cells that contain the scal
params) some worksheet functions, to determine the values from a set o
data. When I did this, the macro didn't work anymore. It didn't pop u
any errors or such things, it just didn't adjust the chart anymore.
I believe the macro doesn't take the "displayed" value of the cells
because, when I input the values manually into the cells, the macr
works fine (i.e. no formulas in the cells, just numbers)
any idea on fixing this?,(without having to install Tushar Mehta'
autochart add-in).
I have attached a testfile with data and a chart, showing the macr
doesn't fix the X axis maximum value.
Thanx in advanc
(min and max values) to cell values in a worksheet. I am using th
macro that I found in Mr Peltier' site:
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
It worked just fine for a simple test I was doing.. BUT, I came up wit
the idea of assigning to the cells (the cells that contain the scal
params) some worksheet functions, to determine the values from a set o
data. When I did this, the macro didn't work anymore. It didn't pop u
any errors or such things, it just didn't adjust the chart anymore.
I believe the macro doesn't take the "displayed" value of the cells
because, when I input the values manually into the cells, the macr
works fine (i.e. no formulas in the cells, just numbers)
any idea on fixing this?,(without having to install Tushar Mehta'
autochart add-in).
I have attached a testfile with data and a chart, showing the macr
doesn't fix the X axis maximum value.
Thanx in advanc