Set the major and minor units of the axis scale on the Format Axis dialog
(get to the dialog by right clicking on the axis).

Add gridlines from the button on the Chart Tools Layout tab.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"dh13134" wrote in message
...
looks like your response applied to Excel 2003. is there something similar
in
Excel 2007?
--
dh13134


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