Hello all,
I have a scatter graph, where the Y-axis values are a mix between values and formulas. I can grab a single point on the line and move it, and depending on if it's a formula point or value, I get the Goal Seek box.
I want to be able to grab the whole line on the chart, move it around, and change the source data. Any ideas?
Steve
I have a scatter graph, where the Y-axis values are a mix between values and formulas. I can grab a single point on the line and move it, and depending on if it's a formula point or value, I get the Goal Seek box.
I want to be able to grab the whole line on the chart, move it around, and change the source data. Any ideas?
Steve