Forum Discussion

mtp03's avatar
mtp03
Frequent Visitor
3 years ago

bar chart x axis show MMM-YY for multiple years without adding them up by month.

I have data that spans to 2019. I need to be able to see the month axis change from any point. The problem is if I select months in different years, it sums them up under 1 month category. 

 

Looks like this with 2 years selected (I want Jan 21, Feb 21, Mar 21... May 22, June 22, July 22, etc.); ignore the colors that show certain categories of data and not the year designation:

 

This is how I have the bar chart axis pulling. I know I probably need another table or something but I cannot figure it out.

 

Need Help

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi mtp03 

    Thanks for reaching out to us.

    you need to add year into axis, otherwise it will not correctly identify which year the same or different months should belong to.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • mtp03's avatar
      mtp03
      Frequent Visitor
      3 years ago

      I have tried that two ways but it ends up summing up all 2021 in one bar and all 2022 in one bar:

       

       

       

      Can you explain what you mean by add the year into the axis?