How To Make Graphs in Microsoft Excel 2007

1. How To Make Graphs in Microsoft Excel 2007

2. Outline • Making Bar Graphs • Making Scatter Plots – 1 series • Making Scatter Plots – Multiple Series

3. Making Bar Graphs

4. Type in your data

5. Select Insert Graph (Scatter Plot) • Select “Insert” tab • Select Scatter -You may choose to have points connected by curved or straight lines

6. Insert Graph Once 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 graph

7. Select Your Data • Select the graph area • Click on the design tab under chart tools • Click on select data Graph area

8. Select Your Data 1. Click on Add series* * If any data was previously selected, select that series and click remove

9. Type in Series Name

10. Select x-axis data for series 1 Do not select the title, just your data points

11. Select y-axis data for series 1

12. 1. Once series 1 is added, you will return to the previous box, click “Add” to add another series

13. Add Series 2 – Type series name

14. Select x-axis data for series 2 Note how the x-axis is the same for this and all series of this graph

15. Select y-axis data for series 2

16. 1. Once series 2 is added, you will return to the previous box, click “Add” to add another series

17. Add series 3 – Type series name

18. Select x-axis data for series 3

19. Select y-axis data for series 3

20. 1. Once series 3 is added, you will return to the previous box, click “Add” to add another series

21. Add series 4 – Type series name

22. Select x-axis data for series 4

23. Select y-axis data for series 4

24. Once you have added all series click “ok” and the “Select Data Source” box will close.

25. Add a title to your graph Under the “Layout” tab in Chart tools, select “Chart Title” and then “Above Chart”

26. Add a title to your graph A title box, like the one shown here, will appear above your graph

27. Type in your title

28. Label the x-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Horizontal Axis Title” and “Title Below Axis”

29. Label the x-axis A title box, like the one shown here, will appear below the x-axis

30. Label the x-axis Type in your x-axis title

31. Label the y-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Vertical Axis Title” and “Rotated Title”

32. Label the y-axis A title box, like the one shown here, will appear next to the y-axis

33. Label the y-axis Type in your y-axis title

34. And 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 “Paste”