Microsoft Excel Charts banner image.

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.

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.