Forum Discussion
David_Abuchar
Jul 27, 2022Copper Contributor
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 ...
HansVogelaar
Jul 27, 2022MVP
Either number the weeks in 2022 as 53, 54, ..., or use dates instead of week numbers.
David_Abuchar
Jul 27, 2022Copper Contributor
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.
- HansVogelaarJul 27, 2022MVP
I assume that your chart is an XY Scatter Chart. If so, change it to a Line chart.
- David_AbucharJul 28, 2022Copper Contributor
Brilliant HansVogelaar! that did the trick! Thanks a lot!