Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color of legend
Maybe
legend.interior.RGB = RGB(255,255,255) "Anique" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
color of legend
Hi Anique,
I don't have '2007 but try - lgd.Fill.Visible = msoTrue Regards, Peter T "Anique" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
color of legend
Sorry , i've tried both answers.. but it still has a transparant background.
The anwer of JLGWhiz doesn't pass the compiler.. en the other answer just doesn;t change the properties... Anyone another idea ?? Thanks in advance Anique "Peter T" wrote: Hi Anique, I don't have '2007 but try - lgd.Fill.Visible = msoTrue Regards, Peter T "Anique" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to place a legend inside a legend | Excel Discussion (Misc queries) | |||
Chart Legend Color Index Assignment | Charts and Charting in Excel | |||
Zero values not legend, Value grater then zero show data and legend | Excel Discussion (Misc queries) | |||
Key/Legend | Excel Worksheet Functions | |||
Legend | Charts and Charting in Excel |