VBA code to chaneg axis text on a chart?

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I've tried this but it doesn't work:

.Axes(xlValue).AxisTitle.Text = "EE"

Thanks in advance to whomever can help!
 
Hi,

These work for me,

activechart.Axes(xlcategory,xlPrimary).hastitle=true
activechart.Axes(xlcategory,xlPrimary).axistitle.text="Category Axis"
activechart.Axes(xlvalue,xlPrimary).hastitle=true
activechart.Axes(xlValue,xlPrimary).axistitle.text="Value Axis"

What exactly does 'doesn't work' mean. Do you get an error message?

Cheers
Andy
 
Andy Pope rocks!!!!!!!!!!!!!!!!!!!!!!!
Again you saved the day!
It works! Thank you sooooooooo much!!!
 

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

Back
Top