Axis title text direction stacked

J

Jim Pan

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

Peter T

Not sure if this is what you mean -

ActiveChart.ChartTitle.Orientation = xlVertical

Regards,
Peter T
 
J

Jim Pan

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?
 
P

Peter T

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
 
Top