Tick Marks On Axis: How, Please ?

[Robert11]

Hello,

Using Excel 2007

How do I puill up something for a chart that allows me to play with the
options for Tick-Marks on one of the axis ?

Thanks,
B.

 

[Bob Umlas, Excel MVP]

Select the axis, use ctrl/1 or right-click & select Format Axis. On the Axis
options section, in the middle, you'll see Major tick mark type, etc --
choose inside, outside, none, or cross. HTH
Bob Umlas
Excel MVP

 

[Robert11]

Hello,

Thank you.

Bob

 

[Dave Peterson]

Maybe you can use a dynamic range.

Debra Dalgleish explains dynamic range names here:
http://contextures.com/xlNames01.html#Dynamic