Below is some data from a questionnaire where the respondent was asked: “What is your favourite ice-cream flavour?”. This data was then analysed by age group.
This arrangement of tabulated data — a set of data series — lends itself to a Stacked Column Chart.
Simply select the range of data, A2:G6 (labels included), activate the Insert menu and select the Stacked Column Chart option.
For completeness, enter custom text in the Chart Title and modify the Y-Axis.