« Thanks to Everyone Who Attended Today's Webcast! | Main | Step-by-Step Instructions for the Excel Webcast Tips »
In last Thursday's webcast, one of the tips I demonstrated was to change data directly on a scatter or other value\value chart by just dragging a data point. Very cool, yes ... BUT ... Jon Peltier, a talented Excel MVP who attended that session, pointed out an extension of that tip that really should be shared ...
You can, in fact, drag data points to change the data directly on category\value charts (i.e., bars, lines, columns, etc.) as well. Instead of dragging to change the data for either axis, you can only change the data for the value axis ... but it's really quite fun :) For example --
Select a single column in a column chart, then hover your mouse pointer over the top edge of the column, and the mouse pointer will change to a double-backed arrow. Then you can click and drag the column up or down the value axis.
Remember, of course, when you change data points on any kind of chart ... the change will be reflected in your source data -- just as if you'd changed it on the data worksheet.
Thanks, Jon! Jon's website is also a great resource for Excel charting tips and tutorials. Check it out if you have a chance...
Posted by Stephanie
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt/mt-tb.cgi/44
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)