This week's topics
One way that I like pie charts is when I am reviewing my my mutual funds data. When I log into my financial accounts, I like to view how much of my money is invested in small cap vs. large cap vs. real estate vs. international by seeing a colorful pie chart. It is marked with a percentage for each category. Can you think of a way you might use a pie chart?
Generally, experts say that pie charts should contain 6 or fewer categories, otherwise, it may be difficult to view.
For step-by-step directions on how to create a pie chart using your Excel data, view the following instructions: https://support.office.com/en-us/article/Add-a-pie-chart-812dccce-9e44-41c6-9091-225c7c3df3e0
Two examples that I use this type of graph is for my financial statements. I like to view my earnings/losses over time. I also like to view my consumers power usage by looking at a line graph. I can see how much power was used during each month. This view makes a good comparison.
Can you think of other examples in which a line chart or graph might be used? What are other types of graphs or charts that we can create using Excel? What might those types of charts/graphs be used to display?
Excel's Goal Seek Analysis Tool
For an explanation and examples of this tool, read the following article written by Susan Harkins http://www.techrepublic.com/article/how-to-use-excels-goal-seek-analysis-tool/
For a different perspective, read the article from Productivity Portfolio: http://www.timeatlas.com/excel-goal-seek/