Hi,
This code isn't working so I've obviously made a mistake somewhere.
My intention is that it gives me a 'Year' label to the horizontal axis and a £ label to the vertical.
Instead, I'm getting a £ label to the horizontal axis and 'Axis Tiitle' displayed vertically and selected on the vertical axis.
Many thanks
This code isn't working so I've obviously made a mistake somewhere.
My intention is that it gives me a 'Year' label to the horizontal axis and a £ label to the vertical.
Instead, I'm getting a £ label to the horizontal axis and 'Axis Tiitle' displayed vertically and selected on the vertical axis.
Many thanks
Code:
'set the horizontal axis
.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
.Axes(xlCategory, xlPrimary).AxisTitle.Text = Range("Yearheader").Value
.Axes(xlCategory).Select
Selection.TickLabels.Orientation = xlUpward
'set the vertical axis - note these are VALUES (revenue) as oppose to CATEGORIES (years) for the horizontal access
.SetElement (msoElementPrimaryValueAxisTitleRotated)
.Axes(xlCategory, xlPrimary).AxisTitle.Text = "£"
.Parent.Name = ("MyChart")
Last edited: