Basic Chart Types

-----------------------------------------------------------------------------------------------------

Pie Chart

Consider using a pie chart when:

  • You have only one data series that you want to plot.
  • None of the values that you want to plot is negative.
  • None of the values that you want to plot is a zero (0) value.
  • You don't have more than seven categories.
  • The categories represent parts of the whole pie.

Learn about creating Pie Charts using Microsoft Excel

Line CHart

Consider using a Line chart when:

  • You want to display continuous data over time, set against a common scale
  • You want to show trends in data at equal intervals or over time
  • Your data has non-numeric x values.

Learn about creating Line Charts using Microsoft Excel

Column Chart

Consider using a column chart when:

  • You have one or more data series that you want to plot.
  • Your data contains positive, negative, and zero (0) values.
  • You want to compare the data for numerous categories side by side.

Learn about creating Column Charts using Microsoft Excel

Combo Chart

Consider using a Combination chart when:

  • You want to emphasize different types of information in one chart
  • Combining chart types will make the chart easier to understand.
  • The range of values for different data series in your chart varies widely
  • You have mixed types of data

Learn about creating Combo Charts using Microsoft Excel

Comment Stream