divingdingo
11-28-2007, 04:09 AM
i'm trying to set the axistitle object for my charts where the x axis is "m/s"
and the y "hrs of day". i know how to set one as i've been using the following code:
activechart.Axes(xlValue, xlPrimary).AxisTitle.Text = "m/s"
however not sure how to set the other as when i've used 'record macro' to help figure out the code it doesn't give me the right code!! and just gives the following:
activechart.Axes(xlvalue, xlPrimary).AxisTitle.Text = "hours of day"
which has the effect of turning "m/s" into "hrs of day"
how frustrating!
regards
mark
and the y "hrs of day". i know how to set one as i've been using the following code:
activechart.Axes(xlValue, xlPrimary).AxisTitle.Text = "m/s"
however not sure how to set the other as when i've used 'record macro' to help figure out the code it doesn't give me the right code!! and just gives the following:
activechart.Axes(xlvalue, xlPrimary).AxisTitle.Text = "hours of day"
which has the effect of turning "m/s" into "hrs of day"
how frustrating!
regards
mark