minor and major gridlines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to have 5 minor gridlines in between each pair of major gridlines on
the value axis. how can i do that?
 
Hi,

Do you mean 5 minor gridlines between each pair of major gridlines (i.e.,
there will be 6 minor sections in each major section; use 1/6 in the
procedure below) or 5 minor sections in each major section (i.e., there will
be 4 minor gridlines between each pair of major gridlines; use 1/5 in the
procedure below)?

Right-click on the axis (X- or Y-) --> "Format Axis" --> "Scale" --> in
"Minor Unit" enter 1/6 (or 1/5, see first paragraph) of the value of the
Major Unit --> "OK"
Now, right-click in the chart area --> "Chart Options" --> click on
"Gridlines" Tab and check both "Major" and "Minor" Gridlines for each axis
--> "OK".
You can format the major and minor gridlines with different line-types,
colors, etc., to make them look distinct.

Regards,
B. R. Ramachandran
 
looks like your response applied to Excel 2003. is there something similar in
Excel 2007?
 
Back
Top