OMIS-Excel Notes-Linda's

News toronto star september 28 2004 business section

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: n the Ribbon); Select a chart format (format options establish the arrangement of data and visual appearance of a chart); Specify a location (the default location is embedded in the worksheet that is currently activated; the chart can be moved to another worksheet or crate a new worksheet that is dedicated for the chart, which is known as 22 Excel Notes Jessica Gahtan OMIS2000 a chart sheet); .Add or adjust the chart and axis titles (titles must be added or adjusted after creating the chart). Figure 5.2 (on slide) shows the selections that were made to create a 2- dimensional column chart. A chart may have any of several formats. Selecting an option called All Chart Types at the bottom of the format list opens the Create Chart dialog box, which provides access to every chart type and format available in Excel. After you select the chart format from either the list shown in Figure 5.2 or the dialog box shown in Figure 5.3, the chart will appear in the worksheet that is currently active (remember this is the default location). Figure 5.4 (in text) shows the column chart created to display the sales of each automobile class from Figure 5.1. This is known as an embedded chart because it appears within a worksheet that could also contain other data. After embedding the chart in a worksheet, you can move it on that worksheet by clicking and dragging the chart frame. You can then adjust the size of the chart by clicking and dragging on any of the dotted areas on the frame. The dotted areas are known as sizing hand...
View Full Document

This note was uploaded on 03/28/2014 for the course OMIS 2000 taught by Professor Hk during the Fall '13 term at York University.

Ask a homework question - tutors are online