Hi,
I have created a yearweek column with the formula below.
It has to be continuous as I put it on the x-axis and then have a vertical reference line. What it does is that it creates a straight line between two years (and some weird yearweek on axis e.g. 201885), even though there are values only for yearweeks 201853 and then 201901. Example below:
What I have tried:
- Making it discrete/string - cannot do it, because I need the continuity for the reference line.
- Edit the format of values and Choose Special Values to have option Marks: Hide (Break Lines). Still no solution. (this was suggested by a user but I accidentally deleted the whole thread, sorry for that)
If anyone has any idea, I would really appreciate it. Sample workbook is attached.
Thanks,
Lea
Lea,
For the Yearweek column I suggest that you keep it as a date using the formula
DATETRUNC('week', [Date] )
Then, you can right-click the axis and select Format and in Scale - Date, select Custom and enter yyyy ww
Using this instead of a float , you eliminate the unexisting weeks like 201854 and more on the axis.
For the parameter, I suggest that you use a date. Again you can use the format yyyyww
check in the attached...
Michel
