minor and major gridlines

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


"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?

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?