How To Make Graphs in Microsoft Excel 2007OutlineMaking Bar GraphsType in your dataSelect Insert Graph (Scatter Plot)Insert GraphSelect Your DataSlide 8Type in Series NameSelect x-axis data for series 1Select y-axis data for series 1Slide 12Add Series 2 – Type series nameSelect x-axis data for series 2Select y-axis data for series 2Slide 16Add series 3 – Type series nameSelect x-axis data for series 3Select y-axis data for series 3Slide 20Add series 4 – Type series nameSelect x-axis data for series 4Select y-axis data for series 4Slide 24Add a title to your graphSlide 26Type in your titleLabel the x-axisSlide 29Slide 30Label the y-axisSlide 32Slide 33And you are done!!!How To Make Graphs in Microsoft Excel 2007Outline•Making Bar Graphs•Making Scatter Plots – 1 series•Making Scatter Plots – Multiple SeriesMaking Bar GraphsType in your dataSelect Insert Graph (Scatter Plot)1. Select “Insert” tab2. Select Scatter -You may choose to have points connected by curved or straight linesInsert GraphOnce you select your type of graph, you will get a box that will likely be empty but may have a graph depending on what you had selected prior to inserting the graphSelect Your Data1. Select the graph area2. Click on the design tab under chart tools3. Click on select dataGraph areaSelect Your Data1. Click on Add series** If any data was previously selected, select that series and click removeType in Series NameSelect x-axis data for series 1Do not select the title, just your data pointsSelect y-axis data for series 11. Once series 1 is added, you will return to the previous box, click “Add” to add another seriesAdd Series 2 – Type series nameSelect x-axis data for series 2Note how the x-axis is the same for this and all series of this graphSelect y-axis data for series 21. Once series 2 is added, you will return to the previous box, click “Add” to add another seriesAdd series 3 – Type series nameSelect x-axis data for series 3Select y-axis data for series 31. Once series 3 is added, you will return to the previous box, click “Add” to add another seriesAdd series 4 – Type series nameSelect x-axis data for series 4Select y-axis data for series 4Once you have added all series click “ok” and the “Select Data Source” box will close.Add a title to your graphUnder the “Layout” tab in Chart tools, select “Chart Title” and then “Above Chart”Add a title to your graphA title box, like the one shown here, will appear above your graphType in your titleLabel the x-axisUnder the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Horizontal Axis Title” and “Title Below Axis”Label the x-axisA title box, like the one shown here, will appear below the x-axisLabel the x-axisType in your x-axis titleLabel the y-axisUnder the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Vertical Axis Title” and “Rotated Title”Label the y-axisA title box, like the one shown here, will appear next to the y-axisLabel the y-axisType in your y-axis titleAnd you are done!!!To copy your graph into a word document, right click on the graph and select “Copy.” In your word document, right click on the blank page and select