Week number format

[beternal]

Hi

Attached is a snippet of the data I am working with.

I have year number in Column A and the week number associated with it in Column B. I would like to plot those data with column D.

I tried concat, to merge the year with the week but then I end up with a gap in the graph between 2050 (year 20, week 50) and 2101 (year 21 week 01).

Ideas how I can sort this?

Really, it's more about plotting the data so answer could be modifying the graph scale... but for the future help with converting two separate columns into something year/week-usable would be very helpful!

Thanks

[Bo_Ry]

Add Date Column from Year and week

=DATE(2000+A2,1,B2*7)

then Plot graph from date and Data

[beternal]

Hi Bo_Ry, that's worked perfectly thanks!

Is there any way to format it though to retain the original format? I.e. on the graph x-axis as 20,1...20,3... or even two separate rows with 20 + 21 and 1, 2, 3...

[Bo_Ry]

Maybe try

=A2+B2/53

and custom format

0-0

/53

and create a new shape to block the /53 on the Axis

[beternal]

Nice workaround, thanks

I'm guessing there's no way to keep them spread out as dates is there? - i.e. to keep the equivalent of a 10 week gap between say 20-31 and 20-41?

You've done more than enough, very much appreciated so this is more a curiosity now