Microsoft Office Tutorials and References
In Depth Information
Specifying the Beginning and End Point for a Series
Excel offers two general types of controls: those from the Forms toolbar and
those from the Control Toolbox toolbar. Controls in the Forms toolbar are
easier to use, but they don’t offer as much flexibility as the Control Toolbox
controls. For example, the controls on the Forms toolbar offer virtually no
formatting options. All the examples in this chapter use controls from the
Specifying the Beginning
and End Point for a Series
If a chart uses a lot of data, you may want to be able to limit the data that’s
displayed in the chart. Figure 7-6 shows an example.
Cell D2 contains a value that represents the first row to be plotted, and cell D4
contains a value that represents the last row to be plotted. The chart is displaying
the data in rows 6 through 13. If cells D2 or D4 are changed, the chart adjusts
accordingly. This example uses Spinner controls linked to cells D2 and D4. These
controls make it easy to change the values in these cells.
Figure 7-6: Cells D2 and D4 control the amount of data that’s displayed in a chart.
Creating the chart
Refer to Figure 7-6 and create a chart from the data in columns A:C. The chart in
this example is a standard column chart. It uses two columns (A:B) for the category
axis labels, which results in having two rows of category labels in the chart.