Making Bar Graphs and Scatter Plots in Microsoft Excel 2007

1. Making Bar Graphs and Scatter Plots in Microsoft Excel 2007

2. Making a Bar Graph

3. Type in your data

4. Make a Table • If you want to put your data in a table: • Select your data • Under the Home tab select the borders icon and then select “All Borders”

5. Insert a Bar Graph Select your data (for bar graphs you may select titles along with your numerical data). Under the “Insert” Tab select “Bar” and click on the bar graph of your choice

6. When you first insert your graph, it will look something like the graph above. You will need to insert appropriate tittles for the x and y axes and change the title of the graph.

7. Label the x-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Horizontal Axis Title” and “Title Below Axis” *Make sure the graph area is selected, otherwise you will not see the chart tools*

8. Label the x-axis Highlight the “Axis Title” box below the graph and type in your x-axis title – Remember to include units.

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

10. Label the y-axis Highlight the “Axis Title” box and type in your y-axis title

11. Delete the Series Box Select the Series Box and click “Delete” on your keyboard

12. Change the Title of Your Graph To change the title of your graph simply highlight the title and type in a title that best descries the data displayed in your graph

13. Add a Title to Your Graph If no chart title box is initially present in your graph ,under the “Layout” tab select “Chart Title” and then “Above Chart”

14. Add a Title to Your Graph Highlight the “Chart Title” box and type in your title.

15. Making a Scatter Plot

16. Type in Your Data

17. Insert your Scatter Plot Select your data (do NOT select the titles) Under the “Insert” tab select “Scatter” and click on the type of graph of your choice (in this case the type of graph is a Scatter with Smooth lines and markers)

18. Insert your Scatter Plot You should get a graph similar to the one shown above. You will need to insert a graph title and axes title (don’t forget to include the units).

19. Label the x-axis Under the “Layout” tab in “Chart tools”, select “Axis Titles”, then “Primary Horizontal Axis Title” and “Title Below Axis.” *Make sure the graph area is selected, otherwise you will not see the chart tools*

20. Label the x-axis Highlight the “Axis Title” box below the graph and type in your x-axis title

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

22. Label the y-axis Highlight the “Axis Title” box and type in your y-axis title

23. Delete the Series Box Select the Series Box and click “Delete” on your keyboard

24. Add a Title to Your Graph Under the “Layout” tab in “Chart tools” select “Chart Title” and then “Above Chart”

25. Add a Title to Your Graph Highlight the “Chart Title” box and type in your title.