As per title, I'm trying to create a graph on excel plotting my weight measured every day. Now, the vertical axis is not a problem, I already have set 3 Series, one for the daily weight, and two for a moving average of 7 and 30 days. The axis was very easy to setup, since I wanted to see weight from 85 to 65 (kg) as max and min, I set 1 for the main line and 0.2 for the secondary line.
But the horizontal axis with the dates is driving me crazy, I understood how excel deals with dates enough to set a min and max, but the subdivisions...
I'm using excel online, I think the correct version name would be 365, but how can I show months as main lines and week as secondary? All it asks is a number, and of course either 29, 30 or 31 don't work after 1-2 months.
I want to see the first of the month as a primary line and the mondays as secondary lines, how do I do that?
Thanks in advance for all the potential support