sharath
03-20-2006, 01:15 PM
Hi All,
Please find below VBA code from macro(.bas).
Set oleGraph = slide1.Shapes.addOLEObject(287.0,93.0,230.0,393,"MSGraph.Chart","",0,"",0,"", 0)
Set chartObject = oleGraph.OLEFormat.Object
oleGraph.Fill.visible=msoFalse
Set dsChart= chartObject.Application.DataSheet
Set chartProxy = chartObject
chartProxy.PlotArea().Fill().ForeColor().SchemeColor = 20
This VBA code is setting foreColor to 20 from schemaColor object, is it possible to set foreColor from RGB values? If possible, then please let me know how to set ForeColor with RGB values?
Regards,
Sharath.
Please find below VBA code from macro(.bas).
Set oleGraph = slide1.Shapes.addOLEObject(287.0,93.0,230.0,393,"MSGraph.Chart","",0,"",0,"", 0)
Set chartObject = oleGraph.OLEFormat.Object
oleGraph.Fill.visible=msoFalse
Set dsChart= chartObject.Application.DataSheet
Set chartProxy = chartObject
chartProxy.PlotArea().Fill().ForeColor().SchemeColor = 20
This VBA code is setting foreColor to 20 from schemaColor object, is it possible to set foreColor from RGB values? If possible, then please let me know how to set ForeColor with RGB values?
Regards,
Sharath.