

Use this chart when you have two or more data series and you want to emphasize the contributions to the whole, especially if the total is the same for each category.ģ-D column 3-D column charts use three axes that you can change (a horizontal axis, a vertical axis, and a depth axis), and they compare data points along the horizontal and the depth axes. A 3-D 100% stacked column chart shows the columns in 3-D format, but it doesn’t use a depth axis. Use this chart when you have multiple data series and you want to emphasize the total.ġ00% stacked column and 3-D 100% stacked column A 100% stacked column chart shows values in 2-D columns that are stacked to represent 100%. A 3-D stacked column chart shows the stacked columns in 3-D format, but it doesn’t use a depth axis.

Stacked column and 3-D stacked column A stacked column chart shows values in 2-D stacked columns. Names that are not in any specific order (for example, item names, geographic names, or the names of people). Specific scale arrangements (for example, a Likert scale with entries like Strongly agree, Agree, Neutral, Disagree, Strongly disagree). Ranges of values (for example, item counts). Use this chart when you have categories that represent: A 3-D clustered column chart shows columns in 3-D format, but it doesn’t use a third value axis (depth axis).

A column chart typically displays categories along the horizontal (category) axis and values along the vertical (value) axis, as shown in this chart:Ĭlustered column and 3-D clustered columnĪ clustered column chart shows values in 2-D columns. Data that’s arranged in columns or rows on a worksheet can be plotted in a column chart.
