{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

OMIS-Excel Notes-Linda's

# Choose format data series add a secondary

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

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

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern