Hi,
please help me making this very simple chart (at least I thought so ..).
I need to make a chart showing one stacked column per year.
My data is shown below. I expected Excel to group the lines by year, but all I get is one column for both years.
So how can this be done? Any help is appreciated.
Stefan
year status number
2016 NEW 197
2016 PASSED 90
2016 REJECTED 31
2017 NEW 175
2017 PASSED 66
2017 REJECTED 88
please help me making this very simple chart (at least I thought so ..).
I need to make a chart showing one stacked column per year.
My data is shown below. I expected Excel to group the lines by year, but all I get is one column for both years.
So how can this be done? Any help is appreciated.
Stefan
year status number
2016 NEW 197
2016 PASSED 90
2016 REJECTED 31
2017 NEW 175
2017 PASSED 66
2017 REJECTED 88