Table used for the chart types below (FIGURE 1)

Clustered Columns Chart (FIGURE 2)

• Popular chart style
• Used for comparing two or more data series vs. time

Customizing a Chart (FIGURE 3)
Charts are easier to customize by selecting the part of the chart you wish to customize, right-button mouse click it, and select the option on the mouse shortcut menu.
 
In this example, I have selected the Product A data series (blue) with mouse (you will know its selected when you see the selection bars around it).
Then right-button mouse click it and select choice from the mouse shortcut menu.

Stacked Columns Chart (FIGURE 4)

• Also popular for comparing two or more data series vs time
• Rather than using two separate columns for Products A and B, they are both shown on one column
• Harder to ascertain data values unless data labels are added

3-D Column Chart (FIGURE 5)

• Used for 2 or more data series vs. time
• Usually shown for looks over substance
• Harder to read data vs vertical axis numbers unless chart is customized

Bar Chart (FIGURE 6)

• Not as popular since most viewers are used to viewing time scale on horizontal axis
• Basically same type of data as clustered column style

Pie Chart (FIGURE 7)

• Good for showing proportion of two or more data series
• Time is not a consideration
• Should limit number of data series
• Since each “slice” represents a series, pie slices will be small and hard to read if too many data series are shown

3-D Pie Chart (FIGURE 8)

• Good for showing proportion of two or more data series
• Time is not a consideration
• Should limit number of data series. Since each “slice” represents a series, pie slices will be small and hard to read if too many data series are shown

X-Y Scatter Chart (FIGURE 9)

• Used to show 2 data series only 
• Time is not a consideration

Line Chart with Markers (FIGURE 10)

• Used for showing one data series vs time
• This is the chart to use for showing trends during a certain time period (Sales increasing or decreasing)