Results 1 to 4 of 4

Thread: Setting RGB color in MSGraph object.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Setting RGB color in MSGraph object.

    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.
    Last edited by Aussiebear; 02-17-2025 at 04:09 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •