Enter Mode Versus Edit Mode

Often, users add data to a chart and then must manually resize the chart to include the new data. I show how to eliminate this repetitive task in Chapter 7, Automating Tasks with the Table Feature, but I want to compare two manual approaches here. Let’s jump in:

1. Activate the Enter Mode Versus Edit Mode worksheet in the example workbook for this chapter.
2. Notice that the chart does not reflect the March values. The first way to resolve this is to do the following:
   1. Click once on the chart.
   2. Drag the Selection Handle shown in cell D5 in Figure 9.7 across to cell E5:

Figure 9.7 – Using the Selection Handle to resize charts

3. At this point, your chart should reflect the month of March.

Nuance

If you don’t see the Selection Handle in Figure 9.7, choose File | Options | Advanced, and then turn on the Enable fill handle and cell drag-and-drop setting.

3. Now, let’s add April and...