Hi.

Thank you very much. The procedure worked.

Thanks again.
Regards,
S. R. Hasan

"B. R.Ramachandran" wrote:

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


"rafi" wrote:

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