Forum Discussion
Helper IWeek & Year in x-axis as type continuous
Hello,
In the X-axis I want to show the calender week and the year combined, e.g. 01/2021, 02/2021, 12/2021, 01/2022, 07/2022 ...
I already created a calendar table.
When I combine cw and year with
"CW/YEAR", WEEKNUM(([Date]),21) & "/" & YEAR([Date])
... the diagramm changed to the type "category" and is still not anymore "continuous". Why I need "continous" is because I don't want to have the scroll bar in the x-xis, when I reduce the width of the diagramm.
Thanks,
Tobias
Tobias106 , You can get continuous axis with number and date only
Create a column like this and use
Week Year = Year([Date])*100 +weeknum([date])
4 Replies
- amitchandak
Super User
Tobias106 , You can get continuous axis with number and date only
Create a column like this and use
Week Year = Year([Date])*100 +weeknum([date])
Tobias106amitchandak ok, my fault. I had a mistake in the additional colum ("&" instead of "*").
Now I have, by using your help, a graph which shows in the x-axis
a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050
b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.
Maybe you can help me agian, that would be great 😊.
To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points
To b) Can I display the last label, 202230?
And 1: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?
And 2: There is much space between the 2 charts (between the chart with the 52 columns for 2021 and the chart with the 30 columns for 2022). Any idea to reduce the space?
Thank you in advance amitchandak
- Tobias106
amitchandak thank you very much. But unfortunetly I need your help again 😊
Now I have, by using your help, a graph which shows in the x-axis
a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050
b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.
Maybe you can help me agian, that would be great 😊.
To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points
To b) Can I display the last label, 202230?
And: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?
Thank you in advance amitchandak
- Tobias106
amitchandak thank you very much. But unfortunetly I need your help again 😊
Now I have, by using your help, a graph which shows in the x-axis
a) A continous column chart for 2021 with 52 columns; the x-axis is named 202100 under the first colum and under the last column 2021050
b) A column chart for 2022 with 30 columns; the x-axis is named 202200 under the first colum and under the last column is no label.
Maybe you can help me agian, that would be great 😊.
To a) Can I display more labels? Only the first and last is not to much, if you have 52 data points
To b) Can I display the last label, 202230?
And: Can I show instead, e.g. 202150 -> 50/2021? So, it's is easier to read?
Thank you in advance amitchandak