Excel 2013 & 2016: Examples of the RIGHT way to do charts

Updated 2013.06.20

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/006-Charts-Good%20Examples_files/image001.jpg

This chart is an appropriate example of a line chart (time is on the horizontal axis). If you handed in a chart like this, you would probably receive full credit for it. It is a line chart and time units run along the x-axis. Everything about this example is correct.

 

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/006-Charts-Good%20Examples_files/image002.jpg

This chart works as a column chart, but it could also be implemented as a line chart. Note that time (years) always goes across the bottom of the chart. Also note that both axes are clearly labeled, and the chart has an easy-to-understand title. Also note the commas in the number on the vertical axis to improve readability.

 

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/006-Charts-Good%20Examples_files/image003.jpg

This works as a pie chart because it includes all of the Marlins' salaries – note the largest part of the chart ("All Others"). If the creator of this chart had not included all others, a pie chart would not have been appropriate.

 

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/006-Charts-Good%20Examples_files/image004.jpg

Good example of a pie chart. It represents 100% of the religions in the United States (even though there are probably many different ones in the "Other" category). Each pie segment is labeled. The chart has a descriptive title.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/006-Charts-Good%20Examples_files/image005.jpg

This is a good example of a column chart. The only change I might make would be to make the text a little larger.