Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

X - AXIS chart design

hi  how to get this desing in X axis  
Need Help
Tips and Tricks
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Anonymous if you haven't tried Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

 

Please perform the following four steps:

1. Select Clustered Column Chart, put Year and Week columns into Axis field (Week at a lower level), and a value in Values field.

2. Click Expand All Down icon on the chart.

3. Go to Format pane and turn off Concatenate labels under X axis. 

4. Click ... on the chart and select Sort axis > Sort ascending and Sort by Year Week.

 

Currently your chart is sorted by Value descendingly. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.