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

E

Ed Smith

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

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
Data points in chart incorrect 0
Overlay line graph points on bar graph 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Plot value at top of chart 1
Flatline on line chart 1

Top