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
|
|||
|
|||
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
|
|||
|
|||
VBA Axis line weight
|
#3
|
|||
|
|||
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 | |
|
|