Trying to add add gradient color to plotarea in chart in excel.
chrt.Chart.PlotArea.Format.Fill.TwoColorGradient (msoGradientVertical, 2)
But this line gives error " expected =" When I set a variable to it, then gives an error was waiting for Function or variable
I looked on web, it is mainly abour adding gradient to bar series collection. But I need to fill gradient of plot area. Any ideas why it gives an error like, or resource suggestions?
