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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automate chart X-axis/data 1
Chart Objects 1
Remove the weekends from a pivot chart x axis 0
VBA to update Chart Source Data Rage on Multiple Charts 1
duplex print 4
Auto Update of Y axis Max, Min and Scale 1
How to Hilight Chart's Source Data? 4
Triggering an UpdatePanel question 1

Back
Top