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).
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Creating Charts and Pivot Tables
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.