A number of different kinds of graphs can be created from your excel data

Graphs are useful when communicating with others or presenting to a group

Bar graphs

Line graphs

Pie charts

Qs: have you ever use charts as opposed to pivot tables?

Often the best way to present a large data set is visually through a graph

Excel gives you many options – bar, line, pie charts

• Go to “Insert” and you’ll see a number of charts are available

◦ Excel will even ‘recommend’ which charts it thinks are best for your data

• The key to creating charts is to ensure your data is correctly input and the X and Y axis are accurate

Quick easy to do

Again, highlight your data, go to insert and you’ll see a number of charts available

Ensure you have your data input correctly and you have identified the X & Y Axis