Stacked Bar Chart

Stacked Bart chart is also used to display bifurcation of multiple categories in Bars. we use this chart when our category names are big.

For example if we have Email Id wise booking data like (Flight booking, Hotel booking and car booking).

Email Id wise booking
Email Id wise booking

We can create a 3D stacked Bar chart for above data.

3D Stacked Bar Chart
3D Stacked Bar Chart

To create above chart below given steps to be followed:

  • Select data range “A1:D6”
  • Go to Insert >>Charts>>Bar Chart>>3D Stacked Bar
Insert 3D stacked bar chart
Insert 3D stacked bar chart

 

After inserting the 3D stacked Bar chart successfully, we will change the chart style.

Select the chart and go to the Design>>Chart Styles>>Style 3

Chart Styles
Chart Styles

Now we will change the chart background color.

Select the chart and go to Format tab>>Shape Styles>>Intense effect – Black, Dark 1

Shape Styles
Shape Styles

Now change the Chart title as “Email Id Wise Bookings”

Our 3D Stacked Bar Chart is ready. Please download this excel file for practice.

3D Stacked Bar Chart
Click on the chart to download the excel file