Hi – I would like to create a column chart that captures three independent variables and a dependent variable relating to the Olympics – (1) year, (2) country, (3) medal type (gold, silver, bronze) and (4) medal count. The year would be the primary variable along the x-axis, and for each year there would be three columns, one for gold, one for silver and one for bronze. The columns would be stacked columns, with a series for each of three or so countries, and the height of the column segment would be the number of medals for that year and medal type.
I know how to create a stacked column chart. What I’m wondering is how to split out three stacked columns, one for each medal type, which are repeated for each year of the data set. Any help you can provide is appreciated.