Excel Charts - Bar Chart


Advertisements

Bar charts illustrate the comparisons among individual items. A Bar chart typically displays categories along the vertical (category) axis and values along the horizontal (value) axis.

Follow the steps given below to use a Bar chart.

Step 1 − Arrange the data in columns or rows on the worksheet.

Step 2 − Select the data.

Step 3 − On the INSERT tab, in the Charts group, click the Bar chart icon on the Ribbon.

Insert Bar Chart

You will see the different types of bar charts available.

A bar chart has the following sub-types −

  • 2-D Bar Charts

    • Clustered Bar

    • Stacked Bar

    • 100% Stacked Bar

  • 3-D Bar Charts

    • 3-D Clustered Bar

    • 3-D Stacked Bar

    • 3-D 100% Stacked Bar

Types of Bar Chart

Step 4 − Point the mouse on each of the icons. A preview of that chart type will be shown on the worksheet.

Preview of Bar Chart

Step 5 − Double-click the chart type that suits your data.

In this chapter, you will understand when each of the Bar chart types is useful.

Clustered Bar and 3-D Clustered Bar

These chart types are useful to compare values across a few categories. A Clustered Bar chart shows bars in 2-D format. A 3-D Clustered bar chart shows bars in 3-D perspective, but it does not use a third value axis (depth axis).

Clustered Bar Chart

You can use Clustered Bar charts when −

  • The chart shows duration.
  • The category text is long.

Stacked Bar and 3-D Stacked Bar

These charts are useful to compare the parts of a whole across various categories and show the change in parts of a whole unit with respect to time.

A Stacked Bar chart displays values in 2-D horizontal stacked rectangles. A 3-D Stacked Bar chart displays the data by using a 3-D perspective, but it does not use a third value axis (depth axis).

Stacked Bar

You can use Stacked Bar charts when the category text is long.

100% Stacked Bar and 3-D 100% Stacked Bar

These charts are useful to compare the percentage that each value contributes to the total unit and show the change in percentage that each value contributes with respect to time.

A 100% Stacked bar chart displays Values in 2-D horizontal stacked rectangles. A 3-D 100% Stacked bar chart displays the data by using a 3-D perspective, but it does not use a third value axis (depth axis).

100% Stacked bar chart

You can use 100% Stacked bar charts when the category text is long.

Advertisements