See all Microsoft Excel tips
Strategy: If your chart is located as an embedded object on a sheet, you can drag and drop new data on the chart.
1) Type the new data for your chart adjacent to the old data, as shown in Fig. 1094. Fig. 1093.
2) Select the entire range, including the new heading for the new month, as shown in Fig. 1095.
3) Using the mouse, grab anywhere on the thick black border (but do not grab the square Fill handle in the lower right). Start to drag the border down towards the chart, as shown in Fig. 1096.
4) When the cell pointer is over the chart, the cursor changes to just an arrow with a plus sign. Release the mouse button. Miraculously, the chart is updated with your new data, as shown in Fig. 1097.
Summary: You’ll never have to waste hours creating new charts each month. Simply copy the new data adjacent to the old data and drag and drop it on the chart. I first saw this trick in a demo at a Microsoft seminar. The “wow” factor was amazing.
See all Microsoft Excel tips