How do I create a stacked bar chart in Excel with multiple sets of data?

Question

I am trying to create a horizontal bar chart that plots four different start times and durations for an activity for multiple people. I need the start times and duration to be on the same bar for each person. I have tried to make stacked bar chart but the vertical axis does not look right. I have attached an image to show my desired effect. I think it might be too much data.

I have been able to chart only one start time and duration on each person, but I need four possible start times and four possible durations on each bar. Thank you for your help.

Answer 1

Hi,

Here's how you can create a stacked bar chart-

1. Head to the "Insert" tab on the Excel ribbon after selecting the data range (including headers).
2. From the "Charts" group, pick a stacked bar chart or a clustered bar chart.
3. After inserting the chart, select "Format Axis" from the context menu by right-clicking on the vertical axis (the one that represents people).
4. Change the "Axis labels" option to "Low" in the "Format Axis" pane to make the bars start on the chart's left side.
5. To make sure all bars are visible, you might also want to set the axis' maximum value to the number of people you have.
6. The chart should now show the beginning and end times for each individual in parallel.

Best Regards.

Answer 2

Hi @engineeringstudent_0413

It would be easy if you attach an image exactly what you want. By the way, I tried to map your requirement in the following Clustered Stacked Bar Chart, hope you will like it.

Following is the data format.

To make similar and advanced charts you can install Excel add-in from here.

Thanks