minor and major gridlines
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?
|