Axis title text direction stacked

  • Thread starter Thread starter Jim Pan
  • Start date Start date
J

Jim Pan

I cannot figure out how to make the axistitle text direction to Stacked. Can
someone help? Thanks.
 
Not sure if this is what you mean -

ActiveChart.ChartTitle.Orientation = xlVertical

Regards,
Peter T
 
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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Using text as data? 0
Chart difference between Excel 2003 and Excel 2007 1
Get/Find criteria and copy sum 2
Clustered Column Chart Containing Stacked Data 1
Stacked Bar Chart 1
Graphing a bounded region with a twist? 1
stacked column graph adjacent to a regular column graph 0
VB Chart 1

Back
Top