Forum Discussion
X axis values
Hello, I need help with the following problem. I have a chart with X axis values that are in Weeks. I want to present data from Week 27 2021 to Week 26 2022. Even though I introduce the data in this order, when Excel reaches Week 1 2022, the line goes to the beginning of the graph. The graph below shows Week 27 2021 to Week 52 2021.
But as soon as I add Week 1 2022 onwards it does the following:
How can I make Week 1 2022 onwards appear after Week 52 2021?
Thanks
4 Replies
Either number the weeks in 2022 as 53, 54, ..., or use dates instead of week numbers.
Thank you HansVogelaar. It is really key to keep the week numbers in the X axis as this is the jargon used in the industry to understand volumes and prices.
I assume that your chart is an XY Scatter Chart. If so, change it to a Line chart.
