making bar graphs and scatter plots in microsoft excel 2007 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Making Bar Graphs and Scatter Plots in Microsoft Excel 2007 PowerPoint Presentation
Download Presentation
Making Bar Graphs and Scatter Plots in Microsoft Excel 2007

Loading in 2 Seconds...

  share
play fullscreen
1 / 25
Download Presentation

Making Bar Graphs and Scatter Plots in Microsoft Excel 2007 - PowerPoint PPT Presentation

ash
109 Views
Download Presentation

Making Bar Graphs and Scatter Plots in Microsoft Excel 2007

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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.