Creating Charts and Pivot Tables. Lesson 10. Objectives. Software Orientation: The Insert Tab. The Insert tab contains the command groups you’ll use to create charts in Excel (see the figure).
NOTE:A ScreenTip displays the chart type name when you rest the mouse pointer over a chart type or chart subtype.
NOTE: The data series is the most important element of the chart. Use formatting tools to call attention to the graphic and the label.
Location group. The Move
Chartdialog box shown in
the figure opens, with the
default setting—New Sheet—selected. This setting places the chart as an object in a new worksheet.
NOTE: The Chart Tools that you used on the Design, Layout, and Format tabs can be applied to the chart sheet. The data series amounts were difficult to read when you applied them to the embedded chart. They are easy to read and can be used for analysis when the chart is moved to a chart sheet.