» Updating Charts by Dragging and Dropping in Microsoft Excel

CATEGORY - Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

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

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 3.21 Views: 30149

Graphs/charts

Katrina Posted on: 31-12-1969

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!?

Reply: Graphs/charts - Katrina from Montreal, Qc wrote on September 1, 2003 11:15 AM EST

Alan Posted on: 31-12-1969

Hi Katrina,

Try plotting your data as a scatter diagram, and then add a line of best fit.

HTH,

Alan.