How to Drag Chart Markers to Change Data in Excel 2007

1. Enter any additional data you wish to add to the chart in cells that are adjacent to your existing worksheet data.
2. Use your mouse to select the chart by left-clicking in the chart area. Notice that a blue rectangle appears around the existing worksheet data used to generate the chart.
3. Move your mouse over one of the corners of the blue rectangle that is adjacent to the new data you just entered. A 2-sided arrow will appear. Drag the blue sizing handle to include the new data and labels in the rectangle.
4. Left-click and hold on the 2-sided arrow, then drag it to increase the size of the rectangle to include all the new data you have just entered. When you release the mouse button, the chart will automatically update to show the new data.
5. Add new data series only, as well as new categories and data points, by dragging the green and purple sizing handles respectively. Green and purple rectangles will also appear when you select the chart, if applicable, just as the blue rectangle did in Step 2.