Moving a line chart data point revises data table value in Excel '
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 |
Moving a line chart data point revises data table value in Excel '
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 "Ed Smith" <Ed wrote in message ... 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 |
Quote:
Hi sorry for bumping this after 5 years but i can't find any other help on the net (probably because i don't know the name). I'm using excel 2002, how do i use this featu i have a line graph with markers and i want to be able to move the markers with my mouse to alter the cell values. Is this possible? Cheers |
All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com