Microsoft Office Tutorials and References
In Depth Information
your worksheet. This technique also makes locating a particular chart easier because you
can change the names of the chart sheets’ tabs to provide a description of the chart that it
The Excel Ribbon changes when a chart sheet is active, similar to the way it changes when
you select an embedded chart. You have access to the same editing tools for embedded
charts and charts on chart sheets.
If the chart isn’t fully visible in the window, you can use the scroll bars to scroll it, or
adjust the zoom factor to make it smaller. You can also change its orientation (tall or wide)
by choosing Page Layout
Parts of a Chart
Refer to the accompanying chart as you read the following description of the chart’s elements.
The particular chart is a combination chart that displays two data series: Sales Calls and Units Sold.
Sales Calls are plotted as vertical columns, and the Units Sold are plotted as a line with circular markers.
Each column (or marker on the line) represents a single data point (the value in a cell). The chart data
is stored in the range A1:C7.
It has a horizontal axis, known as the category axis. This axis represents the category for each data
point (January, February, and so on).
It has two vertical axes, known as value axes, and each one has a different scale. The axis on the left is
for the columns (Sales Calls), and the axis on the right is for the line (Units Sold).