Moving a line chart data point revises data table value in Excel '

G

Guest

I recall a capability I used with Excel years ago that enabled me to create a
line chart from a data table, then move the plot points on the chart to
"smooth" the line, and the source data chart value would change with the
corresponding new plotted point.
I'd like to use that capability with Excel 2007 but can't find to activate it.
Any power users know how?
Thanks!
Ed
 
B

Bob Flanagan

Ed, Microsoft decided that users didn't need that feature. More than
likely, they were tired of support calls asking why the values changed when
one dragged a data point...... No really, they took it out of Excel 2007 to
help users.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not plot a data series in a chart but still display in data table 1
Showing totals in data table in a line chart 3
Plot value at top of chart 1
Line Chart 1
Different data series in table than in the line chart 1
Plotting data points on 2 axis 4
Stopping a chart when the data runs out 9
drag point on line chart to change data in associated cell 5

Top