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 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
- Fall '13
- Jessica 00