| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  44DBF0A-5957-4B47-A343-(E-Mail Removed)...> 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" <(E-Mail Removed)> wrote in message >> news:C4E0A8E6-97C5-4B1B-A797-(E-Mail Removed)... >> >I cannot figure out how to make the axistitle text direction to Stacked. >> >Can >> > someone help? Thanks. >> >> >> |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I am missing text in my y-axis title for my scatter plot | =?Utf-8?B?TWFja2xl?= | Microsoft Excel Charting | 2 | 27th Apr 2006 12:24 AM |
| axis title text box is wrong size in chart for excel 2003 | =?Utf-8?B?aGV5X3Njb3R0?= | Microsoft Excel Charting | 5 | 16th Feb 2006 12:25 AM |
| Y-axis title cutting off in vertical direction | =?Utf-8?B?TWFydGlu?= | Microsoft Excel Charting | 1 | 11th Feb 2006 06:25 PM |
| how to increase area of Y axis title, so full text will be shown? | =?Utf-8?B?ZGFuY2hvNzk=?= | Microsoft Excel Charting | 6 | 15th Nov 2005 04:47 AM |
| 2-direction stacked bar chart | Btibert | Microsoft Excel Charting | 3 | 7th Jul 2005 06:45 PM |
