Microsoft Office Tutorials and References
In Depth Information
Hands-On: Creating a Self-Expanding Chart
Figure 7-1: If this were a self-expanding chart, it would update
automatically when new data is entered.
One option, of course, is to specify a larger-than-required range for the data
series. Figure 7-2 shows an example in which the data series includes empty cells
that will eventually be filled. The result is a lopsided chart that displays lots of
empty space. In the majority of situations, this solution is not satisfactory.
Figure 7-2: Specifying blank cells in the data range is usually not a
As an introduction to the world of interactive charts, this section presents a
hands-on, step-by-step example. You’ll create a standard chart and then make the
changes necessary to make the chart expand automatically when new data is
added, and contract when data is deleted.
The example makes use of a simple worksheet that has dates in column A and
sales amounts in column B. The assumption is that a new date and sales figure are
each added daily, and the chart should display all the data.