Home |
Search |
Today's Posts |
|
#1
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA Axis line weight
|
#3
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For "Marker Line Style" see Point.Format.Line.Weight | Charts and Charting in Excel | |||
Set the line weight with VBA in Excel 07 | Charts and Charting in Excel | |||
Line Weight | Excel Discussion (Misc queries) | |||
Line Weight | Excel Discussion (Misc queries) | |||
Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel |