K
Kai023
I have created a chart that displays Space vs Sales for a given
department for a number of stores for the company I work for. To this I
have applied a logarithmic trendline to show the curve of how sales
change with changes in space & have displayed the equation for this
line.
What I am wondering is, is there a way to capture this equation in to
an Excel cell without manually cutting & pasting it? I have to create a
number of these charts for different departments & need to capture the
equation for each one & doing it manually is taking forever!
If anyone can help, it'd be greatly appreciated.
Thanks
department for a number of stores for the company I work for. To this I
have applied a logarithmic trendline to show the curve of how sales
change with changes in space & have displayed the equation for this
line.
What I am wondering is, is there a way to capture this equation in to
an Excel cell without manually cutting & pasting it? I have to create a
number of these charts for different departments & need to capture the
equation for each one & doing it manually is taking forever!
If anyone can help, it'd be greatly appreciated.
Thanks