question re: excel 2008 - major gridlines for charts

[magnolia89]

Is there a way to individually select which tick marks receive a major gridline? As far as I can tell, the only options are to have all tick marks with a gridline or none. For example, in the image I attached, I want the horizontal axis to cross at -0.5, and I want a gridline at 0, but I don't want gridlines from any of the other vertical ticks. Thanks for any help you can give.

 

[-aggie-]

I don't believe there's any way to do what you want, other than editing a pic of the graph in Photoshop or something similar.

 

[kakapo]

Is there a way to individually select which tick marks receive a major gridline? As far as I can tell, the only options are to have all tick marks with a gridline or none. For example, in the image I attached, I want the horizontal axis to cross at -0.5, and I want a gridline at 0, but I don't want gridlines from any of the other vertical ticks. Thanks for any help you can give.

you can either a) just turn off gridlines and set the x-axis to cross at 0 or b) change the gridline major unit to a large enough value that the next one after 0 would be off your graph.