UNCW MBA 512 - Charts in Excel (6 pages)

Previewing pages 1, 2 of 6 page document View the full content.
View Full Document

Charts in Excel



Previewing pages 1, 2 of actual document.

View the full content.
View Full Document
View Full Document

Charts in Excel

37 views

Other


Pages:
6
School:
University of North Carolina Wilmington
Course:
Mba 512 - Info Systems & Technology

Unformatted text preview:

Charts in Excel Version 2003 Graphs are called charts in Excel There are three pages of charts at the end of this handout Line charts bar charts Excel calls them column charts and pie charts Line charts are typically used to show data over some sequence such as time Bar charts are used to compare data among som categories Pie charts are used to show how data parts combine into a whole To construct the first chart Temperature Over Time choose the Insert command followed by the Chart command and the following screen will appear You should choose the Line chart type Begin by selecting the data to be included in the chart Then using the tab marks Series choose the name values and X axis labels Next you will choose the titles Note that the tab called Legend will let you remove the legend at the right hand side of the chart so that it looks like the example chart You will perform a similar set of instructions to create the chart named Rain vs pH at the end of this handout Bar charts called column charts in Excel Choos the Grades tab at the bottom of your Excel spreadsheet Choose the Insert command followed by the Chart subcommand you wish to choose the side by side bars for the chart type You need to select your data by columns for this example not by rows The values for the Series tab are shown below Next make the titles for the chart the X axis and the Y axix What about the other tabs on this menu Now choose the Sports tab from the Excel spreadsheet Choose to make a pie chart For 9th grade sports we would make the choices below Notice that rows is chosen and not columns for this example Notice that at this time the legend still appears We will change that later You still need to enter values for data for the titles tab as well as the legend tab But the data labels tab values are shown below



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Charts in Excel and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Charts in Excel and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?