minor and major gridlines

[Guest]

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

 

[Guest]

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

 

[Guest]

Hi.

Thank you very much. The procedure worked.

Thanks again.
Regards,
S. R. Hasan

 

[dh13134]

looks like your response applied to Excel 2003. is there something similar in
Excel 2007?

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______