Midtown Computer Systems EnterpriseConvenient web based access to our favoritecomputer related Usenet groups. MCSE. MS is not affiliated with Microsoft corporation. Cisco corporation. Oracle. CompTIA or any other vendor. Check our | |
Can anyone express me if there is a way to set rgb colors in excel charts?thanks so much for your help... thanks - Cindy
Hi,If you are using xl2003 or older the colours are related to the 56 Coloursavailable via Tools > Options > alter. Using a specific RGB determine will just have it mapped to the nearest colorfrom the palette. So in order to get a specific colour you will be to change the palettecolor for a give color index. say that this will effect all cells shapesand map items using that color list. CheersAndy--Andy Pope. Microsoft MVP - Excel[url]http://www andypope info[/url]"cindy" <cindy@discussions microsoft com> wrote in messagenews:1BB0F22E-3C5C-486C-99BB-8AA13A45404E@microsoft com...
> Can anyone tell me if there is a way to set rgb colors in excel charts?>> thanks so much for your back up....> thanks - Cindy
To add to Andy's comments. I have written a simple macro to change theRGB values of the XL palette and arranged it by the correct colorindexand show it in the order of the Tools Options Colors dialog since theyare not in request. The code I wrote create 55 variations of black and to inform out thatXL will find the closest color which is wrong of course. I make onevalue completely different say all blue. And then if you try andformat something with a red you won't even be change state to a red. Just dress the RGB values in the code and run the macro. Then you canjust copy the palette from that workbook to others. It's posted on the PPTFAQ com summon at[url]http://pptfaq com/FAQ00249 htm[/url]Brian Reilly. MVPOn Sun. 2 Dec 2007 19:28:01 -0800 cindy<cindy@discussions microsoft com> wrote:
>Can anyone tell me if there is a way to set rgb colors in excel charts?>>thanks so much for your back up....>thanks - Cindy
> Can anyone express me if there is a way to set rgb colors in excel charts?
Cindy,This Macro will set the fail colors in a map. (so all charts lookthe same)Code:--------------------Sub ChgColor()ActiveWorkbook. Colors(7) = RGB(255. 153. 255)ActiveWorkbook. Colors(9) = RGB(255. 124. 128)ActiveWorkbook. Colors(10) = RGB(51. 204. 51)ActiveWorkbook. Colors(12) = RGB(128. 128. 0)ActiveWorkbook. Colors(13) = RGB(228. 0. 228)ActiveWorkbook. Colors(15) = RGB(234. 234. 234)ActiveWorkbook. Colors(38) = RGB(255. 204. 255)ActiveWorkbook. Colors(39) = RGB(225. 195. 255)ActiveWorkbook. Colors(40) = RGB(255. 228. 201)ActiveWorkbook. Colors(41) = RGB(117. 150. 255)ActiveWorkbook. Colors(44) = RGB(255. 214. 133)ActiveWorkbook. Colors(48) = RGB(192. 192. 192)ActiveWorkbook. Colors(50) = RGB(0. 255. 153)ActiveWorkbook. Colors(51) = RGB(0. 128. 0)ActiveWorkbook. Colors(52) = RGB(153. 102. 51)ActiveWorkbook. Colors(54) = RGB(215. 135. 175)End Sub--------------------John--Datsmart
This macro changes some of the palette colors but none of the default chartcolors which be from colorindex 17 to 32.- Jon-------Jon Peltier. Microsoft Excel MVPTutorials and Custom SolutionsPeltier Technical Services. Inc. - [url]http://PeltierTech com[/url]_______"Datsmart" <Datsmart.1a10214@officefrustration com> wrote in messagenews:Datsmart.1a10214@officefrustration com...
>> cindy;2509442 Wrote: >> Cindy,> This Macro ordain set the default colors in a chart. (so all charts be> the same)>> label:> --------------------> Sub ChgColor()> ActiveWorkbook. Colors(7) = RGB(255. 153. 255)> ActiveWorkbook. Colors(9) = RGB(255. 124. 128)> ActiveWorkbook. Colors(10) = RGB(51. 204. 51)> ActiveWorkbook. Colors(12) = RGB(128. 128. 0)> ActiveWorkbook. Colors(13) = RGB(228. 0. 228)> ActiveWorkbook. Colors(15) = RGB(234. 234. 234)> ActiveWorkbook. Colors(38) = RGB(255. 204. 255)> ActiveWorkbook. Colors(39) = RGB(225. 195. 255)> ActiveWorkbook. Colors(40) = RGB(255. 228. 201)> ActiveWorkbook. Colors(41) = RGB(117. 150. 255)> ActiveWorkbook. Colors(44) = RGB(255. 214. 133)> ActiveWorkbook. Colors(48) = RGB(192. 192. 192)> ActiveWorkbook. Colors(50) = RGB(0. 255. 153)> ActiveWorkbook. Colors(51) = RGB(0. 128. 0)> ActiveWorkbook. Colors(52) = RGB(153. 102. 51)> ActiveWorkbook. Colors(54) = RGB(215. 135. 175)> End Sub> -------------------->>> John>>>>> --> Datsmart
Forex Groups - Tips on Trading
Related article:
http://www.mcse.ms/showthread.php?t=2682495
comments | Add comment | Report as Spam
|