IST 117 -- Excel Lab #5 (Charts/Graphs)
1. Copy the file Excel, Lab 5 from my folder http://www.nv.cc.va.us/home/japalmer/files/excel/excel_lab5.xls to your disk. 2. Create a pie chart that shows the percentage of votes that each candidate received from the state as a whole. Be sure that your pie wedges are labeled, that you have a title for the graph, and that the percentages are actually shown. Put the chart in Sheet 1 below the data. 3. Change to a different "style" of pie chart. 4. Show the same data in a column chart (you don't need to create the graph again, just use the chart toolbox to change the chart type). Practice with sizing and moving the chart. Now delete the column chart. 5. Create a new column chart that shows the votes Clinton received from the nine counties included in the worksheet. Again, be sure you have a title for the graph. Put this chart in Sheet 1 below the data. 6. With the graph and the data showing on the screen -- can you do that? -- change cell D12 to 16,000. Notice that as soon as you "enter" the value, the graph automatically changes to reflect the new value. 7. Now go to the graph and click on one of the columns – you should see “handles” on all the columns. Click on the same column again and you should see the "handles" only on the bar on which you clicked. Grab the end of the bar and move it up or down (your choice). What happens to the data value in the worksheet when you release? Click on undo so that the data and the chart go back to their state before the changes done in step 6 and 7. 8. Create a new graph that displays the county vote counts for Arlington. Make sure you include the row 4 and column C labels. Make this graph a BAR chart. 9. Change the bar chart to a 3-dimensional chart. 10. Add a border to the chart (Format Chart Area) -- you can add any kind of border you want. Notice that you can make a very stylish shadow border quite easily. 11. While you're in the Format Chart Area, you can change the color or pattern of the fill area around the graph if you want. 12. Create a new column chart that will include the votes from Arlington, Clarke, Fairfax, and Loudoun. Notice that Excel will default to making the data series the three candidates (columns). That is fine. You want your graph to include legends (so that you can identify the columns) so make sure you include the labels in column C and the labels in row 4 in the range to be graphed.
IST 117 – Excel, Day 6, Lab
IST 117 – Excel, Day 6, Lab
13. Now switch your graph so that the data sets are row oriented. 14. Create a new chart that is in a separate SHEET that is a pie chart of the Loudoun votes. Be sure you include the labels for the pie wedges (these are in row 4). Once you have the completed pie chart, "explode" the wedge for Clinton. 15. Feel free to experiment a bit with the formatting options that are available to you. You might want to try some of the following: Add a title to the chart and add axes titles Add and remove legends Change the font and/or point size of a label Move a chart to another location in the sheet Add and remove gridlines Add an arrow point to some important element in the chart (draw the arrow from the tail to the point) – from the drawing toolbar Add a comment in a textbox or a “call-out” box (textboxes have their own icon, callout boxes are under AutoShapes) – from the drawing toolbar Add a more interesting graph fill: varied colors, a graphic, or a texture (in Format Chart Area, Patterns Tab, Fill Effects Or any of the other many options you can explore on your own
IST 117 – Excel, Day 6, Lab