Week & Year in x-axis as type continuous

[Tobias106]

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

[amitchandak · Accepted solution]

@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])

[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 

[Tobias106]

@amitchandak 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