Graphical Goal Seek

spg2112 · Mar 6th, 2002, 09:42 AM

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. · Mar 6th, 2002, 10:49 AM

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..."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:42 AM	#1
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	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

Mar 6th, 2002, 10:49 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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..."