I am trying to create a line graph that displays a count of specific jobs done per month. The table looks something like this:
The wanted line graph should then show a count of the "Cleaning" job per month. The wanted result should look something like this:
But what I have right now look like this:
The problem is that the points are barely visible and halfway outside the plot. So my problem is, I need a way to dynamically set the limits of the Y-axis such that the points don't end up like this. I could set a fixed range for the Y-axis, but since some jobs range between 1-3 and some jobs from 80-100, a fixed Y-axis wouldn't be the best.
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.