Wednesday, September 01, 2010

Microsoft Excel Charts and Money

  1. First lets zoom in so we can see everything better.  Change the zoom to 200%. 

  2. Now type in a list of items. 

  3. Add in dollar amounts for each column

  4. Click on the B for the B column.  It will all be highlighted. 

  5. Click the dollar sign at the top. 

  6. Select all the information. 

  7. Before you start the Chart Wizard you have to reset the zoom value to 100%.

  8. Click the Chart Wizard. 

  9. Click the Pie option for the chart. 

  10. Click Next twice.

  11. Go  between the three options of Titles, Legends, and Data Tables. 

  12. Explore all the options you like.

  13. When you are done Click Finish.