Year
Excel Skills
Graphing

Graphs and Charts

Create a chart in Excel

Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline.

Histogram

Histogram: a graphical display where the data is grouped into ranges (such as "100 to 149", "150 to 199", etc), and then plotted as bars (mathsisfun).

Tugwell, C. (2015). Creating histogram charts in Excel. Retrieved from https://www.youtube.com/watch?v=5jNYylB7iwc

Pivot Tables

Line Graph

Line Graph: a graph that shows information that is connected in some way (such as change over time) (mathsisfun).

Teacher's Tech. (2019). How to make a line graph in excel. Retrieved from https://www.youtube.com/watch?v=0jdX22qM8JA

Stem and Leaf Plot

Stem and Leaf Plot is a special table where each data value is split into a "stem" (the first digit or digits) and a "leaf" (usually the last digit) (mathsisfun)

Login to LibApps