Datasheet

Figure 1-9: The icons in the Insert➪Charts group expand to show a gallery of chart subtypes.
Figure 1-10: A column chart with two data series
Switching the Row and Column Orientation
When Excel creates a chart, it uses a set of rules to determine whether the data is
arranged in columns or in rows. Most of the time Excel guesses correctly, but if it
creates the chart using the wrong orientation, you can quickly change it by choosing
Part I: Chart Basics
20
05_044001 ch01.qxp 8/24/07 8:48 PM Page 20