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
View Full Document