Axis title text direction stacked
 

I cannot figure out how to make the axistitle text direction to Stacked. Can
someone help? Thanks.

Axis title text direction stacked
 

Not sure if this is what you mean -

ActiveChart.ChartTitle.Orientation = xlVertical

Regards,
Peter T

"Jim Pan" wrote in message
...
I cannot figure out how to make the axistitle text direction to Stacked.
Can
someone help? Thanks.

Axis title text direction stacked
 

Thanks. It worked. One more question, I want to make my trendline color red.
I used the Border property and set the colorindex = 255. But excel does not
like it. I have only one trendline. How can I do that?

"Peter T" wrote:

Not sure if this is what you mean -

ActiveChart.ChartTitle.Orientation = xlVertical

Regards,
Peter T

"Jim Pan" wrote in message
...
I cannot figure out how to make the axistitle text direction to Stacked.
Can
someone help? Thanks.

Axis title text direction stacked
 

Use the .Color property.

..Color = rgb(255,0,0) ' or 255 or vbRed

Colorindex refers to one of the (pre 2007) 56 palette colours (1-56) or
system black

When applying a Long RGB colour it will match to the closest colour that
already exists in the palette. (red 255 of course exists in a default
palette).

Regards,
Pete T

"Jim Pan" wrote in message
...
Thanks. It worked. One more question, I want to make my trendline color
red.
I used the Border property and set the colorindex = 255. But excel does
not
like it. I have only one trendline. How can I do that?

"Peter T" wrote:

Not sure if this is what you mean -

ActiveChart.ChartTitle.Orientation = xlVertical

Regards,
Peter T

"Jim Pan" wrote in message
...
I cannot figure out how to make the axistitle text direction to Stacked.
Can
someone help? Thanks.