Re: How to catch the colorindex in a series

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Vic,

This is neat if series are Fill types but from the OP's original post he
appears to be working with Line types, which would not include a Fill
property

Regards,
Peter T

"Vic Eldridge" <VicEldridge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8DD1DEF2-52DE-40DE-AE6D-4FC8EF0F45D1@xxxxxxxxxxxxxxxx
> With ActiveChart.SeriesCollection(1)
> .Trendlines(1).Border.ColorIndex = .Fill.ForeColor.SchemeColor
> End With
>
> It's a pity they didn't stick to a single convention.
>
>
> Regards,
> Vic Eldridge
>
>
> "leglouton" wrote:
>
> >
> > Thanks for your feedback but I need of the actual colour. I want to add
> > to my series a trendline with the same color. If I apply the same
> > colorindex with xlautomatic, the colour is different. The property
> > colorindex from an object trendline set to xlautomatic give always the
> > same color (black in my case) for each series.
> >
> > leglouton
> >
> > Peter T a écrit:
> > > If all you want to do is colour your point to the same colour as its
marker,
> > > apply the same colorindex as returned from the marker, even if
xlautomatic.
> > >
> > > You may want to ensure your point has a marker to avoid applying
xlNone,
> > > effectively invisible, eg
> > >
> > > x = .MarkerBackgroundColorIndex
> > > if x = xlNone then x = xlAutomatic
> > > myPoint.border.colorindex = x.
> > >
> > > If you have only one series and vary colors by point, you would need
to do
> > > each point individually.
> > >
> > > Come back if you need the actual automatic colour for some other
reason not
> > > mentioned in your post.
> > >
> > > Regards,
> > > Peter T
> > >
> > > "leglouton" <pouvesle@xxxxxxxxxxxxxxx> wrote in message
> > > news:#s3GODIjFHA.3540@xxxxxxxxxxxxxxxxxxxxxxx
> > >
> > >>How to catch the line or the point's color in an object serie from a
> > >>chart when property is set to xlColorIndexAutomatic.
> > >>
> > >>For example if My_series is a series object with his property
> > >>MarkerBackgroundColorIndex set to xlColorIndexAutomatic. How to catch
> > >>the color give by Excel to fill the points of my series
> > >>
> > >
> > >
> > >
> >
> >


.

Relevant Pages

  • Re: How to catch the colorindex in a series
    ... > to my series a trendline with the same color. ... > colorindex with xlautomatic, the colour is different. ... >> apply the same colorindex as returned from the marker, ... >> Regards, ...
    (microsoft.public.excel.programming)
  • RE: ! Warning ! in Debug
    ... 'warning' in my original post! ... Best regards ... WPARAM wParam, LPARAM lParam) ... A warning is generated regarding the following line: ...
    (microsoft.public.vc.language)
  • Re: httpmodule causes VS.NET to refuse to open solution!
    ... An MVP posting messages for no reason and from the sounds of his replies he ... The original post was a solution to a problem and it said so in the message ... So this response that I'm replying to, ... Regards, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: httpmodule causes VS.NET to refuse to open solution!
    ... An MVP posting messages for no reason and from the sounds of his replies he ... The original post was a solution to a problem and it said so in the message ... So this response that I'm replying to, ... Regards, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Create mail using a group of email addresses.
    ... DGuess, I know how to do that bit, like i put in my original post. ... >> a distribution list with all my friends email addresses on, ... >> the email group name into the BCC field, ... >> Regards. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)