Ask a new question

How can I change the gridlines and gridline labels independently in Excel?

I want to keep the gridlines but only have labels every other gridline. On the y-axis to be specific.
Answer
Answer

Set the Major unit of the y-axis to twice the Minor unit.

Display the minor horizontal gridlines as well as the major horizontal gridlines.

---
Kind regards, HansV
https://www.eileenslounge.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

Hi ._151,

 

Hans’s suggestion should meet your requirement. To help you more, I would like to add a screenshot so that you can find the settings options more efficiently.

Regards,

Rena

-----------------------
* Beware of scammers posting fake support numbers here.
* Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated December 7, 2022 Views 271 Applies to: