Choose the Right Chart Type for your Data

Charts help you visualize numeric data in a graphical format but the problem is there are just too many types of charts to choose from. You have bar charts, bubble charts, pie charts, line histograms and so on.

If you are finding it hard to pick the right chart type for your type of data, refer to chart chooser diagram. Start from the center of the chart chooser diagram and take the route that best matches your data type. Is the data static or does it change over time? Does the chart show a comparison or relationship between data? You may sometimes have to draw more than one chart.

 Excel_2013_Choose_Right_Chart_TypeThe poster, designed by Andrew Abela

Also read Choose the Right Chart Type for your Data – Live Examples

Following is a description of the major chart types available in Excel, with some simple guidelines on when to use each type.

  • Column charts: A column chart, unlike a bar chart to which it is often compared, emphasizes variation over a period of time. In a column chart, categories appear horizontally and values appear vertically, whereas in a bar chart, categories appear vertically. Variations include the cylinder, cone, and pyramid chart subtypes.

  • Line charts: A line chart shows the relationship of the changes in the data over a period of time. Although similar to an area chart, which shows the relative importance of values, the line chart emphasizes trends rather than the amount of change.

  • Pie charts: Pie charts contain just one chart data series. A pie chart shows the relationship of the parts to the whole. To emphasize the importance of one slice of the pie, choose one of the exploded 2-D or 3-D pie charts.

  • Bar charts: A bar chart (horizontal bars) emphasizes the comparison between items at a fixed period of time. This chart type also includes cylinder, cone, and pyramid subtypes.

  • Area charts: An area chart shows the relative importance of values over time. An area chart is similar to a line chart, but because the area between lines is filled in, the area chart emphasizes the magnitude of values more than the line chart does.

  • XY (Scatter) charts: Scatter charts are useful for showing a correlation among the data points that may not be easy to see from data alone. An XY (Scatter) chart uses numeric values along both axes instead of values along the vertical axis and categories along the horizontal axis.

  • Other Charts: All the other types of charts are lumped together on the drop-down gallery that appears when you click the Other Charts command button on the Ribbon’s Insert tab:

    • Stock charts: Stock charts are used to plot stock quotes over a certain time period, such as a single business day or week. Stock charts show nearly any combination of a stock’s highest and lowest values, its open and close values, and the volume of trade for that stock.

    • Surface charts: Surface charts plot trends in values across two dimensions in a continuous curve. In order to use a surface chart, you need at least two data series, both of which are numeric as with an XY (Scatter) chart.

    • Doughnut charts: A doughnut chart is similar to a pie chart except for its ability to display more than one data series (pie charts always graph just a single data series).

    • Bubble charts: Bubble charts compare sets of three values as kind of a combination of an XY (Scatter) chart with an Area chart. When you build a bubble chart, the size of each bubble represented on the x-y grid represents the third set of values being charted.

    • Radar charts: A radar chart shows changes in data relative both to a center point and to each other. This chart type is useful for making relative comparisons among items.

Also read


No Responses

Show all responses

Leave a Reply