Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
rafi
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
B. R.Ramachandran
 
Posts: n/a
Default minor and major gridlines

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?

  #3   Report Post  
Posted to microsoft.public.excel.charting
rafi
 
Posts: n/a
Default minor and major gridlines

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?

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 20
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default minor and major gridlines

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"