OMIS-Excel Notes-Linda's

Choose format data series add a secondary

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: d In a chart can have up to 32,000 values or data points. Data categories are used to: Organize values in a data series Graphical Excellence Graphical Excellence is achieved when… • Large data sets are presented concisely and coherently. • The message being presented by the chart is clear. • The comparison of two or more variables is aided. • The substance of the data, not the form of the graph is prominent. • There is no distortion of the data and findings. Types of Charts – Bar Chart – Column Chart 21 Excel Notes Jessica Gahtan – – – – – – OMIS2000 Line Chart Pie Chart Doughnut Chart Scatter Chart Cone, Cylinder, and Pyramid Charts Surface Chart Column Charts • Most common chart type used to present business data. • Can compare data at a specific point in time • Can show how this comparison changes over a period of time Column Charts (Data Comparisons)—is the most common chart type used to present business data and is most useful when making comparisons. For example, it can compare the earnings of companies within an industry, sales projections for a new business, or the sales growth of product categories. The column chart can compare data at a specific point in time or show how this comparison changes over a period of time. Figure 5.1 (in text) shows 4 years’ worth of data for a hypothetical car manufacturer. The example demonstrates the construction of a column chart that compares the sales for each automobile class in column A for the year 2006. Then a second column chart will show how the sales for each auto class changes over a 4- year period. Creating a chart in Excel typically involves 5 steps: Identify the data that will be used to define the X- and Y- axes values (you can highlight a range of cells before selecting a chart type); Select a chart type (chart types are available in the Insert tab o...
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