Re: microsoft graph color palette

From: Steve Rindsberg (abuse_at_localhost.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 10:59:41 EDT

> It seems that VBA does not recognize RGB values, because
> it does not allow me to change colors of series to an RGB
> value within a chart either.
> This is what I tried (And this code can also be looked up
> in several sources VBA Graph Help, MSDN library) :
>
> Sub changeseriecolor()
> Set myChart = ActiveWindow.Selection.ShapeRange(1) _
> ..OLEFormat.Object.Application.chart
> myChart.SeriesCollection(2).Interior.Color _
> = RGB(Red:=2, Green:=110, Blue:=6)
> End Sub
>
> And indeed then the color will be replaced by an index
> color. It is very confusing I think when both the Help
> file and MSDN library gives this code and it does not work.

Yes, it is. That's one of the reasons I trust the advice I get here more than
what appears in Help and MSDN.

Relevant Pages

  • Change color scheme of MS Graph with VBA
    ... It seems that VBA does not allow to change color schemes or RGB values ... I have found code in the MSDN library on Intranet and VBA ... Sub changeseriecolor() ...
    (microsoft.public.powerpoint)
  • Re: Use embedded Excel to provide RGB
    ... I am not really familiar with VBA. ... Larry ... Since PP can show color in RGB, ... >calculation routine and then show objects in the calculated color. ...
    (microsoft.public.powerpoint)
  • simulating click events
    ... Is there a way to simulate the clicking of a control through vba? ... Sheet1 contains a label named 'l12' and will change colors when clicked, ...
    (microsoft.public.excel.programming)
  • Re: How to set Word colors in c#?
    ... The 2007 Theme Colors are not RGB values. ... The whole thing is described here: http://www.wordarticles.com/Articles/Colours/2007.htm - it gives VBA code but you can use the same hex values in any language. ... This is a VBA group after all... ...
    (microsoft.public.word.vba.general)
  • Programatically dim (lighten the color) of a cell.
    ... I know I can read the RGB value of a color in VBA. ... Is there a consistent way to do a calculation on those values to visually ...
    (microsoft.public.excel.programming)