How did they design this ? How should my data look like? [on hold]

sample chart

How did they design this ? How should my data look like? Can excel count so many variables ?