Forum Discussion
RexMundane
Dec 05, 2024Copper Contributor
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 2020 information to be on top of the Cranbrook 2015 information, etc. Can you please advise me how to do that? Thanks!
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.
- Rodrigo_Steel Contributor
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.
- RexMundaneCopper Contributor
Amazing! Thank you very much!
- RexMundaneCopper Contributor
I have a work around. I manually move the rows so they are underneath each other, then let excel make the stacked bar graph.
- RexMundaneCopper Contributor
The source data is publically available at https://www2.gov.bc.ca/assets/gov/data/statistics/economy/input-output-model/local_area_economic_profiles_2023_toolkit.xlsx