Graphical Goal Seek

[spg2112]

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

 

[Mark W.]

No, this functionality is for individual data points only. The Help Index topic for
"Change values in a chart by dragging data markers and using goal seeking" states, "...drag the data marker...", and "data marker" is defined as "A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value..."