Excel Chart

Emphasizes the magnitude of change over time

• Area

• Bar

• column

• pie

Illustrates comparisons among individual items

• bar

• column

• line

• xy scatter

Compares values across categories

• radar

• combo

• column

• area

Combines more than one type of chart for example, a column chart and a line chart, which would easily identify data that reflects an average

• combo

• line

• pie

• Radar

Displays trends over time

• line

• xy scatter

• stock

• surface

Data that is proportional to the sum of an item

• Pie

• Radar

• Combo

• Column

Plots changes in data relative to a center point

• Radar

• XY Scatter

• Stock

• Surface

Compare pairs X & Y values in one data point used for statistical or engineering information

• XY Scatter

• Surface

• Pie

• Combo

Used mostly for financial industry, visually illustrates fluctuations

• Stock

• Surface

• Pie

• Column

Finds the optimal combination between two sets of data

combination between two sets of data

• Pie

• Radar

• Surface

• combo