View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
srinivas Tirumala[_2_] srinivas Tirumala[_2_] is offline
external usenet poster
 
Posts: 3
Default what is the alternative for PlotArea.Fill. Fill property is hidden

Chart Object.PlotArea.Fill returns ChartFillFormat object. But in 2007 both
the ChartFillFormat object and property Fill of PlotArea are hidden.

Actual requirement is like following.
.PlotArea.Fill.Visible = True
.PlotArea.Fill.OneColorGradient Style:=msoGradientHorizontal, Variant:=1,
Degree:=0.3

But the functionality works fine in Office 2007. But according to Excel
object model 2007 reference above shown property is hidden, can u please
tell me what is hidden. What is the alternative for this property?

Can any one please help me. Thanks in advance.