Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hmmmm............thanks Jon, I'll check it out
I appreciate the comeback Vaya con Dios, Chuck, CABGx3 "Jon Peltier" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change axis info on radar charts | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Graphing Reversing the Axis | Setting up and Configuration of Excel |