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" 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 |
All times are GMT +1. The time now is 05:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com