Line graph points at edge of plot

[Anonymous]

I am trying to create a line graph that displays a count of specific jobs done per month. The table looks something like this:

Month	Hours	Job
Jan	3	Cleaning
Jan	4	Cleaning
Mar	7	Cleaning
Mar	5	Repair
Apr	6	Cleaning

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.

Is there some way for solving this?

[v-xiaoyan-msft]

Hi @Anonymous ,

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.

[amitchandak · Accepted solution]

@Anonymous , on scatter(line) plot, take a month on the axis and Job as a legend and then try.