Forum Discussion
Solved
Excel graphing help to show grouped data
Hi there, I would like to make a stacked bar chart to display this data but I would like, for example, the Kimberley 2020 information to be on top of the Kimberley 2015 information, the Cranbrook 202...
You first need to make sure sort your table/data so that the regions (e.g., Kimberley, Cranbrook) are grouped together, and within each region, the 2020 data comes above the 2015 data.
To do that:
- Select the entire table.
- Go to Data → Sort.
- Sort by Region Name (A to Z) as the first level.
- Add another level to sort by Ref_Year (2020 first, then 2015).
Then create a stacked bar chart.
You first need to make sure sort your table/data so that the regions (e.g., Kimberley, Cranbrook) are grouped together, and within each region, the 2020 data comes above the 2015 data.
To do that:
- Select the entire table.
- Go to Data → Sort.
- Sort by Region Name (A to Z) as the first level.
- Add another level to sort by Ref_Year (2020 first, then 2015).
Then create a stacked bar chart.
Amazing! Thank you very much!
