Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Category Axis
I am trying to format my category axis (y). I can change font and alignment
angle but am unable to set alignment such as right, left, justify, etc. I have managed to wrap text by using char(10) in my table formula but cannot seem to change the alignment by the data cell format in table. Cheers |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Category Axis
The category axis is always the X axis, regardless of whether it's vertical
or horizontal. But your uncertainty indicates you're using a horizontal bar chart. It is not possible to change the orientation of wrapped text in axis tick labels. Excel centers them and that's all. You can work around this deficiency by hiding the default labels and adding text boxes, or creating a dummy series whose data labels provide replacement axis labels. Both data labels and text boxes allow horizontal alignment adjustments. To simulate an axis using a dummy series and its data labels, follow one of these protocols: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" <Me wrote in message ... I am trying to format my category axis (y). I can change font and alignment angle but am unable to set alignment such as right, left, justify, etc. I have managed to wrap text by using char(10) in my table formula but cannot seem to change the alignment by the data cell format in table. Cheers |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Category Axis
Thank you Jon. I am a novice at charting and your reply helped a lot.
Is there anyway to change the axis area size or is this always going to be governed by the size of the length of text ? Me ! "Jon Peltier" wrote: The category axis is always the X axis, regardless of whether it's vertical or horizontal. But your uncertainty indicates you're using a horizontal bar chart. It is not possible to change the orientation of wrapped text in axis tick labels. Excel centers them and that's all. You can work around this deficiency by hiding the default labels and adding text boxes, or creating a dummy series whose data labels provide replacement axis labels. Both data labels and text boxes allow horizontal alignment adjustments. To simulate an axis using a dummy series and its data labels, follow one of these protocols: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" <Me wrote in message ... I am trying to format my category axis (y). I can change font and alignment angle but am unable to set alignment such as right, left, justify, etc. I have managed to wrap text by using char(10) in my table formula but cannot seem to change the alignment by the data cell format in table. Cheers |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Category Axis
You can change the size of the plot area. Click inside the innermost
rectangle, the one that contains the plotted data. Use the little black handles to resize this rectangular area. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" wrote in message ... Thank you Jon. I am a novice at charting and your reply helped a lot. Is there anyway to change the axis area size or is this always going to be governed by the size of the length of text ? Me ! "Jon Peltier" wrote: The category axis is always the X axis, regardless of whether it's vertical or horizontal. But your uncertainty indicates you're using a horizontal bar chart. It is not possible to change the orientation of wrapped text in axis tick labels. Excel centers them and that's all. You can work around this deficiency by hiding the default labels and adding text boxes, or creating a dummy series whose data labels provide replacement axis labels. Both data labels and text boxes allow horizontal alignment adjustments. To simulate an axis using a dummy series and its data labels, follow one of these protocols: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" <Me wrote in message ... I am trying to format my category axis (y). I can change font and alignment angle but am unable to set alignment such as right, left, justify, etc. I have managed to wrap text by using char(10) in my table formula but cannot seem to change the alignment by the data cell format in table. Cheers |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Category Axis
Thank you Jon. I have tried this before but cannot pick up and change the
axis size just the plot size. No to worry, will soldier on with what i have. thanx again for your help. Me ! "Jon Peltier" wrote: You can change the size of the plot area. Click inside the innermost rectangle, the one that contains the plotted data. Use the little black handles to resize this rectangular area. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" wrote in message ... Thank you Jon. I am a novice at charting and your reply helped a lot. Is there anyway to change the axis area size or is this always going to be governed by the size of the length of text ? Me ! "Jon Peltier" wrote: The category axis is always the X axis, regardless of whether it's vertical or horizontal. But your uncertainty indicates you're using a horizontal bar chart. It is not possible to change the orientation of wrapped text in axis tick labels. Excel centers them and that's all. You can work around this deficiency by hiding the default labels and adding text boxes, or creating a dummy series whose data labels provide replacement axis labels. Both data labels and text boxes allow horizontal alignment adjustments. To simulate an axis using a dummy series and its data labels, follow one of these protocols: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Me !" <Me wrote in message ... I am trying to format my category axis (y). I can change font and alignment angle but am unable to set alignment such as right, left, justify, etc. I have managed to wrap text by using char(10) in my table formula but cannot seem to change the alignment by the data cell format in table. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Category axis formatting and justification | Charts and Charting in Excel | |||
Formatting a category axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel |