﻿Common Chart Types

# Common Chart Types

Selecting the right chart or graph will depend on the data you are trying to plot.

In this topic we will look at some of the more common chart types.

Steps:

1. Highlight the data you want to plot

Step 1
2. Click the Insert  tab

Create a column chart

Step 2
3. Column Chart:  Charts used to display data arranged in columns and rows.  Column charts are useful for showing data over a period of time.

Create a column chart by highlighting your data and selecting Column

Step 3
4. In this example we will use the 100% Stacked Column in 3-D

Step 4
5. This is a column chart

Step 5

6. Highlight your data and select Insert

Step 6
7. Line Chart:   Line charts display data that is set over a period of time, data sued to display a trend.

To create a line chart select Line

Step 7
8. In this example we will use Stacked line with Markers

Step 8
9. This is a Line Chart

Step 9

10. Highlight your data and select Insert

Step 10
11. Pie Chart:  Charts used to display single data series.

To create a pie chart select Pie

Step 11
12. In this example we'll select Pie in 3-D

Step 12
13. This is a pie chart

Step 13

14. Highlight your data and select Insert

Step 14
15. Bar Chart:  These charts are similar to column charts but display at a horizontal angle.    Bar charts are used to compare individual items.

To create a bar chart select Bar

Step 15
16. In this example we'll use 100% Stacked Bar in 3-D

Step 16
17. This is a Bar Chart

Step 17

18. Highlight your data and click Insert

Step 18
19. Area Chart:  Area charts are used to emphasize the magnitude or rate of change.

To create an area chart select Area

Step 19
20. In this example we'll use Stacked Area in 3-D

Step 20
21. This is an Area Chart

Step 21

22. Highlight your data and click Insert

Step 22
23. Scatter (XY) Chart:   Chart used to show a correlation between values.

To create a scatter chart select Scatter

Step 23
24. In this example we'll use Scatter with Smooth Lines and Markers

Step 24
25. This is a Scatter Chart

Step 25

After completing this exercise, you are familiar with some of the common chart types.