Excel - Create stacked column chart
Budget: $10 – $30 AUD
I have a spreadsheet with 9 tables, one for each year 2013 to 2021. Each table has a total closing stock figure at the bottom right made up of the 3 figures to the left. For example, the year 2013 has a total closing stock of 5142 made up of 320 + 3952 + 870.
I want a stacked column chart which has the closing stock figures on the y axis with a stacked column for each year showing the 3 components in different colors and the total. I.e. the years 2013-2021 are the x axis.
I want a stacked column chart which has the closing stock figures on the y axis with a stacked column for each year showing the 3 components in different colors and the total. I.e. the years 2013-2021 are the x axis.