Can't change x axis labels in my scatter plot
I apologize for the screenshots being in Polish. I'm trying to make two graphs. Top one is air (orange) and water (blue) temperature. Bottom one is number of toads encountered on each day. But I'm running into an issue, exel won't label the X axis how I want. As you can see the dates are not equaly apart, sometimes it's one day apart, sometimes 2 or more days apart (dd.mm format). On the bottom plot you can see that exel automatically spaces the x axis lines. I know I can change the spaces inbetween, but it still ads days that don't exist in my data.
A solution I tried in the top graph is changing the x axis to just be normal numbers 0-12. I thought I could somehow change what they're labelled as but I can't. I tried changing the dates to text, numbers, everything, and nothing worked.
I also looked at tutorials, they all could edit the labels, but my edit button for the x axis is grey, non clickable.
Link to the tutorial - https://www.youtube.com/watch?v=QtnuGRT-jyE
Basically I'm having a similiar issue to this guy - https://www.youtube.com/watch?v=rJWUTe_b-Hs
Maybe what I want just isn't possible with a scatter plot because my dates are unevenly spaced?
One workaround I thought about was leaving the plot as it is, with numbers 0-12 and editing it later manually in an image editing software. Or making it by hand from scrap but that would be annoying.
I can send more screenshots, also open to suggestions. As you can probably see I'm a bit lacking on the math theory part of scatter plots.
[link] [comments]
Want to read more?
Check out the full article on the original site