minor and major gridlines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi.

Thank you very much. The procedure worked.

Thanks again.
Regards,
S. R. Hasan
 
looks like your response applied to Excel 2003. is there something similar in
Excel 2007?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Major and minor gridlines on logarithmic axis excel 2007 7
Why do I get some missing minor gridlines in an excel chart? 3
Gridlines & Tick marks 1
2007 line chart, can't make some gridlines heavier than others 10
Format Y-Axis 1
ScatterPlot Major and Minor Horizontal Gridlines not showing 3
Move gridlines in a chart so that they are above the numbers 1
Gridlines ok in Excel but linked powerpoint- lines are missing 1

Back
Top