Modify chart X axis

  • Thread starter Thread starter Gil D.
  • Start date Start date
G

Gil D.

Hello,

I have a form with ChartA.
How can I modify ChartA X axis caption by using VBA code ?

Thank you
Gil D.
 
Hello,

I found that the following commands set the chart X-AXIS label:
Me.FormProjectsForPeriodChart1.Object.Application.Chart.Axes(2).HasTitle
= True
Me.FormProjectsForPeriodChart1.Object.Application.Chart.Axes(2).AxisTitle.caption="title"

My problem is that it does not work unless the chart is not empty and
is displayed on the screen.
I tried to check chart's query recordsource in order to determine if
the chart is empty,
but I don't know how to check if the chart is already displayed on the
screen.

How can I check if the chart is displayed on the screen and so it's
x-axis can be modified ?

Thank you
Gil
 
Back
Top