PC Review


Reply
Thread Tools Rate Thread

VBA code to chaneg axis text on a chart?

 
 
Newbie
Guest
Posts: n/a
 
      24th Mar 2010
I've tried this but it doesn't work:

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

Thanks in advance to whomever can help!

 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      25th Mar 2010
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

On 24/03/2010 20:35, Newbie wrote:
> I've tried this but it doesn't work:
>
> .Axes(xlValue).AxisTitle.Text = "EE"
>
> Thanks in advance to whomever can help!
>


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Reply With Quote
 
 
 
 
Newbie
Guest
Posts: n/a
 
      25th Mar 2010
Andy Pope rocks!!!!!!!!!!!!!!!!!!!!!!!
Again you saved the day!
It works! Thank you sooooooooo much!!!


"Andy Pope" wrote:

> 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
>
> On 24/03/2010 20:35, Newbie wrote:
> > I've tried this but it doesn't work:
> >
> > .Axes(xlValue).AxisTitle.Text = "EE"
> >
> > Thanks in advance to whomever can help!
> >

>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need PivotChart x axis to cross Y axis at minimum Y axis value =?Utf-8?B?QWFyb24=?= Microsoft Excel Charting 1 17th Aug 2007 08:51 AM
chaneg directory were site is hosted =?Utf-8?B?bWF0dA==?= Microsoft Frontpage 2 8th Apr 2007 12:07 PM
Chaneg a yes/no field through VB code =?Utf-8?B?Rm9sbGFuQQ==?= Microsoft Access VBA Modules 2 22nd Jul 2005 12:19 AM
How to insert X axis scale values next to axis and X axis grid lin =?Utf-8?B?dnAyM2xhcnJ5?= Microsoft Excel Charting 2 23rd Jun 2005 03:45 PM
axis axis, scr axis, etc named folders Windows XP General 1 3rd Jun 2004 01:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:20 PM.