Forum Discussion

RexMundane's avatar
RexMundane
Copper Contributor
Dec 05, 2024

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:

    1. Select the entire table.
    2. Go to Data → Sort.
    3. Sort by Region Name (A to Z) as the first level.
    4. Add another level to sort by Ref_Year (2020 first, then 2015).

    Then create a stacked bar chart.

  • Rodrigo_'s avatar
    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:

    1. Select the entire table.
    2. Go to Data → Sort.
    3. Sort by Region Name (A to Z) as the first level.
    4. Add another level to sort by Ref_Year (2020 first, then 2015).

    Then create a stacked bar chart.

  • RexMundane's avatar
    RexMundane
    Copper 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.

     

  • RexMundane's avatar
    RexMundane
    Copper 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

Resources