Multiple year data displayed chronologically

[WxShady13]

HELP!!! I have several years worth of data (i.e. Headcount, Terminations, etc.) all on the same table with a single date field. When I sort by Months obviously it will group all months data together and not distinguish by year. I need to actually display the data by week and if possible not make use of a Year slicer (i.e. just a rolling 12 months worth of data by week.) Right now when it is displayed I cannot get the visual (line graph) to distinguish between years, and stay within the confines of the visual (it pops up a scroll bar at the bottom). What can I do?

 

[CSmith]

This? Move or resize chart

Checkbox 'Don't move of size with cells'

 

[sandy666]

I don't know structure there but
- you can zoom out chart then resize width
- filter Year&Week to show only what client want

 

[sandy666]

I'll leave, I don't want to interfere too much