Prev: Copy chart with associated table
Next: Excel 2007
From: SteveG on 15 Dec 2009 11:00
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
From: Herbert Seidenberg on 15 Dec 2009 13:37
Excel 2007 Chart
Format Axis
http://www.mediafire.com/file/ozmyqzi2ymk/12_15_09.xlsm
From: Peter T on 17 Dec 2009 10:07
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" <steve31530(a)gmail.com> wrote in message
news:53cfebe5-8a16-4503-acf3-b7f59167d293(a)r24g2000yqd.googlegroups.com...
>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


 | 
Pages: 1
Prev: Copy chart with associated table
Next: Excel 2007