In Excel, how do I make a stacked bar graph with 2 bar that have different data points?

Question

So I have the following data:

Data

I made 2 stacked bars with these data, notice both bar have different data points, my question is, how do I merge them to the same graph so I can compare them?

Chart 1 Chart 2

I would like something to look like this, is it possible?:

score 0 · Answer 1 · answered Nov 18 '13 at 20:22

0

A simple solution would be to have all 7 columns in your data table, and then fill in 0's for the values that don't apply to one row or the other.

answered Nov 18 '13 at 20:22

Russell Zahniser

16,188
39
30

In Excel, how do I make a stacked bar graph with 2 bar that have different data points?

1 Answers1

Linked