I'm using Excel 2007 by default but I have access to 2010 and 2013 if later versions provide a solution.
I'm attempting to chart data on student numbers. My data has 3 variables: year (2009, 2010, 2011), mode of study (full time or part time), status of student (home or overseas) - in reality there are more options for each variable but I thought if I can get it to work for a simplified dataset I can hopefully use the same technique for more complex data.
What I'd like to achieve is a combination of clustered and stacked bars. So for each year there would be clustered columns for status and those columns would be stacked to show mode of study. I've attached a small file of example data.
If it's simply not possible to do this, can anyone suggest another way of visualising the data?
Thanks in advance.
Bookmarks