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).
We can create a 3D stacked Bar chart for above data.
To create above chart below given steps to be followed:
- Select data range “A1:D6”
- Go to Insert >>Charts>>Bar Chart>>3D Stacked Bar
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
Now we will change the chart background color.
Select the chart and go to Format tab>>Shape Styles>>Intense effect – Black, Dark 1
Now change the Chart title as “Email Id Wise Bookings”
Our 3D Stacked Bar Chart is ready. Please download this excel file for practice.