Forum Discussion
X - AXIS chart design
hi
how to get this desing in X axis
Anonymous if you haven't tried Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?
6 Replies
Hello there ! Have you tried to use the arrowd in the upper right corner to "Expand all down one level in the hierarchy"?
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️Anonymous
Anonymous if you haven't tried Tahreem24 solution have you tried creating a Year/week hierarchy and using it in the x axis?
Anonymous Take Bar chart and add Week number and Year columns in X-Axis. Then click on expand button on the chart.
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.
