Share via

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

engineeringstudent_0413 0 Reputation points
2023-07-22T14:57:18.77+00:00

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.

Microsoft 365 and Office | Excel | For business | Windows

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Qaiser Javed 0 Reputation points
    2024-08-16T16:40:20.6966667+00:00

    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.

    Clustered Stacked Bar Chart

    Following is the data format.

    User's image

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

    Thanks

    1 person found this answer helpful.
    0 comments
  2. Tanay Prasad 2,260 Reputation points
    2023-07-24T06:11:54.9833333+00:00

    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.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.