How to Create Stacked Bar Chart with Dates in Excel (3 Examples)

Get FREE Advanced Excel Exercises with Solutions!

A stacked bar chart makes it easy to visualize a large dataset. There are three types of stacked bar charts available in Excel: stacked bar charts, 100% stacked bar charts, and 3-D stacked bar charts. If you are looking for some special tricks to create a stacked bar chart with dates in Excel, you’ve come to the right place. This article will discuss three suitable examples of creating a stacked bar chart with dates in Excel. Let’s follow the complete guide to learn all of this.


Excel Stacked Bar Chart with Dates: 3 Suitable Examples

In the following section, we will use three effective and tricky methods to create a stacked bar chart with dates in Excel. To create a more understandable stacked bar chart, first, we organize our dataset, then create a stacked bar chart, and finally, customize the graph by adding graph elements and editing the graph layout. This section provides extensive details on these methods. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.


1. Create Stacked Bar Chart with Dates in Excel

Here, we will demonstrate how to make a stacked bar chart. At first, we have to prepare a dataset containing daily sales of different products as shown below. Let’s walk through the following steps to create a stacked bar chart with dates.

📌 Steps:

  • First of all, input the dates in the range of cells B5:B10 and sales of different products of the corresponding date in the range of cells C5:E10. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Create Stacked Bar Chart with Dates in Excel

  • Now, we are going to insert a stacked bar chart for our dataset.
  • First of all, select the range of the cells B5:E10.
  • Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.
  • Then, choose the Stacked Bar Chart.

How to Create Stacked Bar Chart with Dates in Excel

  • As a consequence, you will get the following stacked bar chart.

  • To modify the chart style, select Chart Design and then, select your desired Style 8 option from the Chart Styles group.

  • As a consequence, you will get the following bar chart.

How to Create Stacked Bar Chart with Dates in Excel

  • Now, we are going to add graph elements. In Quick Elements, some elements are already added or removed. But you can manually edit the graph to add or remove any elements of the chart by using the Add Chart Element option.
  • After clicking on the Add Chart Element, you will see a list of elements.
  • Next, you have to click on them one by one to add, remove or edit.

How to Create Stacked Bar Chart with Dates in Excel

  • Alternatively, you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • You will find an arrow on the element, where you will find other options to edit the elements.

  • For instance, if you want to remove the gridline from the chart, you need to uncheck the Gridlines from the Chart Elements icon options.

How to Create Stacked Bar Chart with Dates in Excel

  • Therefore, you will get the following stacked bar chart with dates.

How to Create Stacked Bar Chart with Dates in Excel

Read More: How to Create Stacked Bar Chart with Negative Values in Excel


2. Create 100% Stacked Bar Chart with Dates in Excel

Here, we will demonstrate how to make a 100% stacked bar chart. At first, we have to prepare a dataset containing sales of crude oil prices and retail gas prices on different days. Let’s walk through the following steps to create a 100% stacked bar chart with dates.

📌 Steps:

  • First of all, input the dates in the range of cells B5:B10 and sales of crude oil and retail gas of the corresponding date in the range of cells C5:D10. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Make a 100% Stacked Bar Chart with Dates in Excel

  • Now, we are going to insert a stacked bar chart for our dataset.
  • First of all, select the range of the cells B5:D10.
  • Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.
  • Then, choose the 100% Stacked Bar Chart.

How to Create Stacked Bar Chart with Dates in Excel

  • As a consequence, you will get the following stacked bar chart.

  • To modify the chart style, select Chart Design and then, select your desired Style 8 option from the Chart Styles group.

How to Create Stacked Bar Chart with Dates in Excel

  • As a consequence, you will get the following bar chart.

  • Now, we are going to add graph elements. In Quick Elements, some elements are already added or removed. But you can manually edit the graph to add or remove any elements of the chart by using the Add Chart Element option.
  • After clicking on the Add Chart Element, you will see a list of elements.
  • Next, you have to click on them one by one to add, remove or edit.

How to Create Stacked Bar Chart with Dates in Excel

  • Alternatively, you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • You will find an arrow on the element, where you will find other options to edit the elements.

Now, we will be able to customize the 100% stacked bar chart as your requirement by editing the Chart Elements. For instance, if you want to remove the gridline, you need to uncheck the Gridlines. Also if you want to add axis titles, you need to check the Axis Titles from the Chart Elements and rename the axis based on your dataset.

Read More: How to Create Stacked Bar Chart for Multiple Series in Excel


3. Create 3-D Stacked Bar Chart with Dates in Excel

Here, we will demonstrate how to make a 3-D stacked bar chart. At first, we have to prepare a dataset containing the number of sales of laptops mobile, and desktops on different days. Let’s walk through the following steps to create a 3-D stacked bar chart with dates.

📌 Steps:

  • First of all, input the dates in the range of cells B5:B10 and the number of sales of laptops mobile, and desktops of the corresponding date in the range of cells C5:E10. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Create 3-D Stacked Bar Chart with Dates in Excel

  • Now, we are going to insert a stacked bar chart for our dataset.
  • First of all, select the range of the cells B5:E10.
  • Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.
  • Then, choose the 3-D Stacked Bar Chart.

How to Create Stacked Bar Chart with Dates in Excel

  • As a consequence, you will get the following 3-D stacked bar chart.

  • To modify the chart style, select Chart Design and then, select your desired Style 6 option from the Chart Styles group.

How to Create Stacked Bar Chart with Dates in Excel

  • As a consequence, you will get the following bar chart.

  • Now, we are going to add graph elements. In Quick Elements, some elements are already added or removed. But you can manually edit the graph to add or remove any elements of the chart by using the Add Chart Element option.
  • After clicking on the Add Chart Element, you will see a list of elements.
  • Next, you have to click on them one by one to add, remove or edit.

How to Create Stacked Bar Chart with Dates in Excel

  • Alternatively, you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • You will find an arrow on the element, where you will find other options to edit the elements.

How to Create Stacked Bar Chart with Dates in Excel

Now, we will be able to customize the 3-D stacked bar chart as your requirement by editing the Chart Elements. For instance, if you want to remove the gridline, you need to uncheck the Gridlines. Also if you want to add axis titles, you need to check the Axis Titles from the Chart Elements and rename the axis based on your dataset.

Read More: How to Create Stacked Bar Chart with Line in Excel


💬 Things to Remember

✎ Before inserting a stacked bar chart, you must select anywhere in the dataset. The rows and columns will need to be manually added otherwise.

✎ When working with a large dataset, avoid stacked charts since they will create confusing graph information.

✎ If you want to switch rows and columns remember that before switching rows and columns, make sure they are all selected.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try yourself while you go through the step-by-step process.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may be able to create a stacked bar chart with dates in excel. If you have any queries or recommendations, please share them in the comments section below. Keep learning new methods and keep growing!


Related Articles


<< Go Back to Stacked Bar Chart in ExcelExcel Bar ChartExcel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo