Updating Charts by Dragging and Dropping in Microsoft Excel

If you have a chart with data for 1999 through 2001 and then enter a new column for 2002, you can drag and drop the new data on the chart.
Highlight the cells with the new data E1:E7. Using the mouse, click the black border around the range and begin dragging the range towards the chart. When the mouse pointer is over the chart, release the mouse button.

Result:
the new data is added to the chart. Screenshot // Updating Charts by Dragging and Dropping in Microsoft Excel
Updating Charts by Dragging and Dropping in Microsoft Excel

Users are saying about us...

  1. I am able to create a line chart but I don’t know how to plot the data so the computer can make a best-fit line on the chart for me. Please help me!?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube