Just an excel query on charts;
Is it possible to pull the co-effciencts from the trend line which resides on a chart and put them into a cell to refernced to elsewhere in a spreadsheet?
(ie. trend line will give formula of y=0.5x^0.2 - can the 0.5 and 0.2 be automatically referred to so if the cell values change.)
Thanks
Is it possible to pull the co-effciencts from the trend line which resides on a chart and put them into a cell to refernced to elsewhere in a spreadsheet?
(ie. trend line will give formula of y=0.5x^0.2 - can the 0.5 and 0.2 be automatically referred to so if the cell values change.)
Thanks