Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Monthly X-Axis with Weekly Data on Line Chart

Hi folks!   I have weekly data over multiple years that I'm trying to display in a line chart. The goal is to show one line for each year, with 52 data points intact, but on an X-Axis that only sho...
Need Help
Washivale's avatar
Washivale
Icon for Resolver V rankResolver V
7 years ago

Hi Anonymous ,

 

Assuming you are adding Week Ending/Week Starting date in Line Chart, consider changing X axis Type to "Categorical" using Format option of Visual, let me know if it works. 

 

 

Also, you should look for options like showing last 16-24 weeks in single visual instead of 52 weeks). Adequate data points will make your visual better to understand for end users.

 

Thank you,

Sandeep

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the reply, Sandeep!

 

These are the settings I'm using:CalDate is normalized to 2019 dates for prior years

 

CalDate is set as Categorical

Here is what I get when I set the X-Axis to Categorical (and standardize the weekly dates to all be in the same year - 2019):Weekly Dates on Axis, Set as Categorical

What I'm hoping to achieve is the same view, but with only Months on the X-Axis, as in the original post's Excel example.