1 / 17

Making Data Into Charts

Making Data Into Charts. Using Microsoft Excel. Organizing Your Data. The first step to creating a chart or graph is organizing your data. It can be organized either vertically or horizontally. Horizontal. Vertical. Organizing Your Data. Typically data is presented vertically

xena
Download Presentation

Making Data Into Charts

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. Making Data Into Charts Using Microsoft Excel by Rene F. Pack, MIS

  2. Organizing Your Data The first step to creating a chart or graph is organizing your data. It can be organized either vertically or horizontally Horizontal Vertical by Rene F. Pack, MIS

  3. Organizing Your Data Typically data is presented vertically Once you have your data organized you can begin the process of making a chart Vertical by Rene F. Pack, MIS

  4. Pie Charts • We will begin with a Pie Chart • A Pie Chart shows the part of the whole • Step 1: Select the titles and the data(DO NOT select the “Total(s)”, you only want the data in a Pie Chart.) Select the data and your titles Do not select the totals by Rene F. Pack, MIS

  5. Pie Charts • Step 2: Click the Insert tab on the Ribbon Click “Pie” in the Charts group Click “Insert” tab Click “Pie” Charts Group by Rene F. Pack, MIS

  6. Pie Charts • Step 3: Click the first 2-D Pie in the list by Rene F. Pack, MIS

  7. Pie Charts • Step 4: Voilà…a Pie Chart by Rene F. Pack, MIS

  8. Pie Charts • Step 5: If you want labels on the “pieces” of the Pie, position your mouse pointer over the pie and click the right mouse button • Step 6: Click “Add Data Labels” in the pop-up menu by Rene F. Pack, MIS

  9. Pie Charts • Step 7: Now your chart should look like the one belowIf you want to change the labels just right click on one of the labels in the chart and click “Format Data Labels” by Rene F. Pack, MIS

  10. Pie Charts • Step 8: In the Format Data Labels Dialog Box, in the Label Options group you can choose a variety of label contents including • Series Name • Category Name • Value • Percentage In this case we will use Percentageand make sure that there is a check markin “Show Leader Lines” • Step 9: In the Label Position group choose “Outside End” • Step 10: Click “Close” by Rene F. Pack, MIS

  11. Pie Charts • Here is your new chart by Rene F. Pack, MIS

  12. Single Line Chart • Just like the Pie Chart • Step 1: Select the titles and the data(DO NOT select the “Total(s)”, you only want the data in your chart.) Select the data and your titles Do not select the totals by Rene F. Pack, MIS

  13. Single Line Chart • Step 3: Click the first 2-D Line in the list by Rene F. Pack, MIS

  14. Single Line Chart • Step 4: Voilà…a Line Chart by Rene F. Pack, MIS

  15. Multiple Line Chart • When you have Multiple Line Charts you are comparing data. For Instance comparing sales from one year to another and in this case we will be comparing 2011 to 2012 sales • Step 1: Select the titles and the data for both years(DO NOT select the “Total(s)”, you only want the data in your chart.) Select the data and your titles by Rene F. Pack, MIS

  16. Multiple Line Chart • Step 3: Click the first 2-D Line in the list by Rene F. Pack, MIS

  17. Multiple Line Chart • Step 4: Voilà…a Multiple Line Chart by Rene F. Pack, MIS

More Related