Forum Discussion

Stuart123's avatar
Stuart123
Regular Visitor
3 years ago

How to create a clustered column chart with multiple years

Hello

 

I'm trying to create a clustered column chart. The x axis has the months of the year. However, I want to be able to compare two years at once (so there is a column for January 2021 and right next to it a column for January 2022, then Feb 2021 and Feb 2022 etc).

The data for the 2 years are coming from different sheets but the variables are the same.

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Stuart123 , One way is month on axis and year on legend 

     

    Month Year = FORMAT([Date],"mmm")
    Month Year sort = month([DAte]) //mark this as sort column of month 

     

     

    Else use month year column sorted on the column given below

     

    Month Year = FORMAT([Date],"mmm-yyyy")
    Month Year sort = FORMAT([Date],"mmyyyy")

     

    How to Create Sort Column and Solve Related Errors:
    https://www.youtube.com/watch?v=KK1zu4MBb-c