|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2009, 04:00 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
VBA Axis line weight
I am trying to set a number of parameters on a chart but am missing a
way to set the axis line thickness (weight)? I have XLS 2007. With ActiveChart.Axes(xlValue, xlPrimary) .AxisTitle.Font.Name = "Arial" .AxisTitle.Font.Size = 12 .AxisTitle.Font.Bold = True .AxisTitle.Font.ColorIndex = 16 .AxisTitle.Top = 70 .AxisTitle.Left = 43 .TickLabelPosition = xlTickLabelPositionLow .TickLabels.Font.Name = "Arial" .TickLabels.Font.Size = 12 .TickLabels.Font.Bold = False .TickLabels.Font.ColorIndex = 16 End With I keep hitting a brick wall with with axis.width so that can't be it! Steve 
|
|
#2
December 15th, 2009, 06:37 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA Axis line weight
|
|
#3
December 17th, 2009, 03:07 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA Axis line weight
Dim ax As Axis
Set ax = ActiveChart.Axes(xlValue, xlPrimary) ' only do this in xl2007+ ax.Format.Line.Weight = 2.25 Regards, Peter T "SteveG" wrote in message ... I am trying to set a number of parameters on a chart but am missing a way to set the axis line thickness (weight)? I have XLS 2007. With ActiveChart.Axes(xlValue, xlPrimary) .AxisTitle.Font.Name = "Arial" .AxisTitle.Font.Size = 12 .AxisTitle.Font.Bold = True .AxisTitle.Font.ColorIndex = 16 .AxisTitle.Top = 70 .AxisTitle.Left = 43 .TickLabelPosition = xlTickLabelPositionLow .TickLabels.Font.Name = "Arial" .TickLabels.Font.Size = 12 .TickLabels.Font.Bold = False .TickLabels.Font.ColorIndex = 16 End With I keep hitting a brick wall with with axis.width so that can't be it! Steve
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
