| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Axis title text direction stacked
I cannot figure out how to make the axistitle text direction to Stacked. Can
someone help? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am missing text in my y-axis title for my scatter plot | Charts and Charting in Excel | |||
| axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
| Y-axis title cutting off in vertical direction | Charts and Charting in Excel | |||
| how to increase area of Y axis title, so full text will be shown? | Charts and Charting in Excel | |||
| 2-direction stacked bar chart | Charts and Charting in Excel | |||
Linear Mode
