Building Charts and Graphs with Excel
Building Charts and Graphs with Excel
Pie Chart of Categorical Data
A Pie Chart shows how a 100% of a quantity goes into different categories.
Step 1
Enter the data in the spreadsheet. The data that goes into the chart are the response categories and the counts for each response.
Sometimes the data is sorted by frequency before entering so that the chart will progress from the largest to the smallest category.
| |A |B |C |
|1 |Conducting Appraisals |No. | |
| |since Training | | |
|2 |Much Easier |5 | |
|3 |Easier |8 | |
|4 |Same |3 | |
|5 |Difficult |1 | |
|6 |More Difficult |0 | |
|7 | | | |
Step 2
Highlight the table. Include row and column labels.
Move the mouse to cell A2; Press the mouse button and move the mouse to Cell B7 while still pressing on the mouse button. Release the button.
Step 3
Start the Chart Wizard.
Press the Chart on the Standard Toolbar, or on the Menu Bar, select Insert/Chart.
Step 4
• Choose Pie as Chart type. ( In my example, I selected the chart in the upper left corner as Chart sub-type. ) You can use the “Press and Hold” button below the diagrams to view a sample of your selection.
• Click Next and confirm the data range.
• Click Next for the Chart Options box.
⇒ Under the title tab, give the chart a title. (I used Performance Appraisals).
⇒ Choose the Legend Tab to locate the position of the Legend, if you choose to use one.
⇒ Choose the Data Labels Tab to indicate how to label the segments. If you do not want a legend, try, ”Show Label and Percent.” You can also show a preference for leader lines here.
• Click Next and specify the location of the chart. (I choose to include it on the existing sheet.)
• Click Finish and the chart is inserted.
Step 5
Use the Chart Toolbar to edit the finished product.
Note: if you change the data in your reference table, there is an automatic change in Chart that reflects the change.
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- free tables and graphs worksheets
- reading charts and graphs practice
- graphs with r
- excel 2016 charts and graphs
- creating graphs in excel 2016
- bar graphs in excel 2016
- creating graphs in excel video
- line graphs in excel 2016
- 3d graphs in excel 2016
- speed time graphs with explanation
- advanced excel charts and graphs
- sample excel charts and graphs