Forum Discussion

isam2003's avatar
isam2003
Helper I
3 years ago
Solved

Issue with aligning years in chart

Hello:

I am trying to align two horizontal bar charts (data has different underlying basis) so as to make comparisons easier.  Somehow the years do not align as can be seen in the screen shot below. Any guidance would be much appreciated. Thanks.

 

4 Replies

  • edhans's avatar
    edhans
    Community Champion

    Not sure what you mean by "not align" unless they are off a pixel or two. If that is the case, select each visual, then in the Properties pane, general section, and manually make sure the Horizontal/Vertical coordinates are correct, and the height/width is the same. Even if the numbers are the same, adjust them all up/down 1 pixel. I've seen when you drag these around the number in the report might be 338, but in the JSON file for the report it can be 337.85 or something, which happens when dragging with the mouse on occasion.

     

     

  • My apologies if I was not clear earlier.  

    GilbertQ edhans The two bars in each chart are for years 2022 and 2023.  However, the order of the years is not consistent.  In the left chart,  2022 is followed by 2023 and in the right chart, 2023 is followed by 2022.  The order of the years is what i am trying to align.  Thanks.

    • GilbertQ's avatar
      GilbertQ
      Super User

      Hi isam2003 

       

      You should then be able to sort it by the Years?

  • Hi isam2003 

     

    What you can do for the X-Axis is to set the Minimum and Maximum values so that it will keep them consistent