1 / 27

Chapter 2 Excel: Presenting data

Chapter 2 Excel: Presenting data. Pie chart. Enter the categories and frequencies data from Example 2.3 in the spreadsheet. Click and drag the cursor over the data .

maciel
Download Presentation

Chapter 2 Excel: Presenting data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 2 Excel: Presenting data

  2. Pie chart • Enter the categories and frequencies data from Example 2.3 in the spreadsheet.

  3. Click and drag the cursor over the data. • Click the Insert tab at the very top of the screen then RecommendedCharts from the choices displayed below the row of tabs.

  4. Click on the pie chart image in the Recommended Charts window then click OK.

  5. The pie chart appears in the spreadsheet.

  6. Simple bar chart • Follow the instructions on slides 1 and 2 above to bring up the Recommended Charts window.

  7. Click on the vertical bar chart image in the Recommended Charts window then click OK.

  8. The bar chart appears in the spreadsheet. • The symbols by the top left of the diagram can be used to configure the diagram.

  9. Stacked bar chart • Enter the data from Example 2.4. Put the retailers in one column, the transactions with cards in a second and those without cards in a third.

  10. Click and drag the cursor over the data. • Click the Insert tab at the top of the screen then RecommendedCharts from the choices displayed below the row of tabs.

  11. Click on the Stacked Column bar chart image in the Recommended Charts window then click OK.

  12. The stacked bar chart appears in the spreadsheet. • The symbols by the top left of the diagram can be used to configure the diagram.

  13. Cluster bar chart • Follow the instructions on slides 9 and 10 above to bring up the Recommended Charts window. • Click OK to select the Clustered Column bar chart.

  14. The cluster bar chart appears in the spreadsheet. • The symbols by the top left of the diagram can be used to configure the diagram.

  15. Histogram • Enter the data from Example 2.11 into a column. • Click and drag the cursor over the data. • Click the Insert tab at the top of the screen then RecommendedCharts from the choices displayed below the row of tabs.

  16. In the Recommended Charts window click the All Charts tab at the top and select Histogram from the list of charts that appears. • Click OK.

  17. The histogram appears in the worksheet. • To change the classes click on the horizontal axis of the diagram.

  18. In the Format Axis window that appears click the Bin width button. • Enter 20 in the space to the right and press Enter.

  19. The modified histogram appears in the spreadsheet. • The symbols by the top left of the diagram can be used to configure the diagram.

  20. Scatter diagram • Enter the data from Example 2.24 into two columns. • Click and drag the cursor over the data. • Click the Insert tab at the top of the screen then RecommendedCharts from the choices displayed below the row of tabs.

  21. In the Recommended Charts window click the All Charts tab at the top and select X Y (Scatter) from the list of charts that appears.

  22. Click on the diagram to the right in the window that appears and click OK.

  23. The scatter diagram appears in the worksheet. • To change the starting point of the Temperature scale click on the horizontal axis of the diagram.

  24. In the Format Axis window that appears click the space to the right of Minimum under Bounds. • Enter 10 and press Enter.

  25. The modified scatter diagram appears in the spreadsheet. • The symbols by the top left of the diagram can be used to configure the diagram.

  26. Time series chart • Enter the data from Example 2.25 into a column. • Click and drag the cursor over the data. • Click the Insert tab at the top of the screen then RecommendedCharts from the choices displayed below the row of tabs. • Click OK.

  27. The chart appears in the worksheet. • The symbols by the top left of the diagram can be used to configure the diagram

More Related