Microsoft Office Tutorials and References
In Depth Information
When you click a chart subtype, Excel creates the chart by using the default layout and
color scheme defined in your workbook’s theme.
KEYBOARD SHORTCUT Press Alt+F11 to create a chart of the default type on the current
worksheet or press F11 to create a new chart sheet. Unless you or another user changed
the default, Excel creates a column chart. For a complete list of keyboard shortcuts, see
“Keyboard shortcuts” at the end of this topic.
If Excel doesn’t plot your data the way that you want it to appear, you can change the axis
on which Excel plots a data column. The most common reason for incorrect data plotting
is that the column to be plotted on the horizontal axis contains numerical data instead of
textual data. For example, if your data includes a Year column and a Maintenance column,
instead of plotting maintenance data for each consecutive year along the horizontal axis,
Excel plots both of those columns in the body of the chart and creates a sequential series
to provide values for the horizontal axis.