LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default color of legend

I ve got an excel sheet which is converted from excel 2003 to 2007.
Unfortunately the background color of the legend is now transparant.
Can anyone tell me how to change this dynamically ?

i've tried:
legend.fill.backcolor.RGB = RGB(255,255,255)
but this doesn't work

thanks in advance.

Anique
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to place a legend inside a legend 2Quick Excel Discussion (Misc queries) 0 April 21st 09 07:41 PM
Chart Legend Color Index Assignment Bob Barnes Charts and Charting in Excel 2 February 18th 09 06:56 PM
Zero values not legend, Value grater then zero show data and legend Pamela[_3_] Excel Discussion (Misc queries) 1 January 28th 09 10:20 AM
Key/Legend Dont_b_Flat88[_2_] Excel Worksheet Functions 1 August 12th 08 08:54 PM
Legend NAS Charts and Charting in Excel 2 December 1st 05 04:16 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"