While I've shown how to drag and drop data on a chart, that method doesn't work if your chart is on a different worksheet than the data. Today in Episode 897...
Transcript of the video:
Alright, welcome back to the MrExcel netcast, I'm Bill Jelen. Here's a cool trick I picked up from one of my seminars down in Virginia last week. Normally, I always show the trick that, if we have a chart and we have new data for that chart, that we can take the data and drag it and drop it right on the chart.
Now, that works in Excel 2003; in Excel 2007, to do the same thing, you would use the blue outline. So click on the chart, you get the blue outline, and you can just drag that blue outline to show the new data. But what happens if the chart is not on the same worksheet as the data? Well, you know, then these tricks just don't work. But it turns out there's the third way to get that data onto the chart.
So here I have a chart sheet with January, February, March, and April. The original source data is here, you see that we now have data from May. If I take that data, including the heading, and I copy it using Ctrl+C, and then come back to the chart; click on the chart; and do Ctrl+V; sure enough, that trick works exactly the same as dragging and dropping new data on the chart.
Great way to very quickly add new data to an existing chart, even if it's on a different sheet.
There you have it, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
Keywords for this video: Microsoft, Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Charting
This video is current as of January 5, 2009