Setting the X axis scale/font

Hi All.....

I don't do much charting, and I'm trying to set the scale on my X axis.
What I would like, is similar to a ruler, with Large font at the 1 marks,
medium font at the 1/2 marks, and small font or just tick marks at the .1
marks. I don't seem to be able to find where/how to make those adjustments.
I can't even get the "minor" scale increments to work, such as 1 for major
and .2 for minor.......the best I've been able to do is to set both major
and minor to .2 and then I get them all, but all at the same font
size.......my X range is 0-4, and I'm using XL97.

Any help would be appreciated.....

Vaya con Dios,
Chuck, CABGx3

Chuck -

You only get two classes of axis ticks. Major has labels, Minor has
none. All the labels use the same font format.

To get the flexibility you want, you'd need to set up an arbitrary axis
scale:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

which uses a dummy series for positioning and data albels as tick
labels. Data labels can be independently formatted, unlike axis tick labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

CLR wrote:

> Hi All.....
>
> I don't do much charting, and I'm trying to set the scale on my X axis.
> What I would like, is similar to a ruler, with Large font at the 1 marks,
> medium font at the 1/2 marks, and small font or just tick marks at the .1
> marks. I don't seem to be able to find where/how to make those adjustments.
> I can't even get the "minor" scale increments to work, such as 1 for major
> and .2 for minor.......the best I've been able to do is to set both major
> and minor to .2 and then I get them all, but all at the same font
> size.......my X range is 0-4, and I'm using XL97.
>
> Any help would be appreciated.....
>
> Vaya con Dios,
> Chuck, CABGx3
>
>

Hmmmm............thanks Jon, I'll check it out

I appreciate the comeback

Vaya con Dios,
Chuck, CABGx3



"Jon Peltier" <[email protected]> wrote in message
news:[email protected]...
> Chuck -
>
> You only get two classes of axis ticks. Major has labels, Minor has
> none. All the labels use the same font format.
>
> To get the flexibility you want, you'd need to set up an arbitrary axis
> scale:
>
> http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
>
> which uses a dummy series for positioning and data albels as tick
> labels. Data labels can be independently formatted, unlike axis tick
labels.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> CLR wrote:
>
> > Hi All.....
> >
> > I don't do much charting, and I'm trying to set the scale on my X axis.
> > What I would like, is similar to a ruler, with Large font at the 1
marks,
> > medium font at the 1/2 marks, and small font or just tick marks at the
..1
> > marks. I don't seem to be able to find where/how to make those
adjustments.
> > I can't even get the "minor" scale increments to work, such as 1 for
major
> > and .2 for minor.......the best I've been able to do is to set both
major
> > and minor to .2 and then I get them all, but all at the same font
> > size.......my X range is 0-4, and I'm using XL97.
> >
> > Any help would be appreciated.....
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >