dhartford
12-21-2008, 11:31 AM
I'm creating the Scatter Plot chart (excel) from Access VBA. Does anyone know what property of the chart is to label the X and Y axis?
Thank you very much in advance.
Not sure about Access VBA but this does it for XL VBA. HTH. Dave
With ActiveChart
'chart name
.HasTitle = True
.ChartTitle.Characters.Text = "Chart Name"
'X axis name
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "X-Axis"
'y-axis name
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Y-Axis"
End With
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.