How to add additional horizontal gridlines on a graph?

[alpha-san]

Hello, how can I change the number of horizontal gridlines on a graph? I want to be able to add more gridlines to my graph.

For example, the graph above has only four gridlines, how can I increase this?

Thank you

[v-huijiey-msft · Accepted solution]

Hi @alpha-san ,

Hope all is going well.

In order to solve your problem, I did many tests and then found the solution to your problem, it is so convenient.

Please follow these steps:

1. Select the Visualizations tab on the right.

2. Select "Y-Axis Constant Line".

3. Select "Add line".

In this function, you can add as many horizontal grid lines as you want.

Where "Value" represents the value at which you want to add horizontal grid lines. "Color" represents the color of the horizontal grid lines. "Transparency" represents the transparency of horizontal grid lines. "Style" indicates the style of horizontal grid lines, including Dashed, Solid, and Dotted. "Data label" indicates whether the data points of the current horizontal grid line are displayed next to the horizontal grid line.

Should you have any questions or concerns, please do feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[alpha-san]

Thank you so much for your response!

[Daniel29195]

@alpha-san 

you can play with the min and max of the y-axis 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[alpha-san]

Hello, thanks for your response. Sorry my post wasn't very clear. I was trying to figure out how to add additional gridlines by adding more y-axis labels. Like this:

Do you know how to do this? Thank you.

[Daniel29195]

@alpha-san 

refer to @v-huijiey-msft  solution . 

this should do the trick