Hi.

I need to apply the same color to the bars in a graph (via VBA),
wether the graph has 3 bars or 7 bars.

The problem that i face is that when the point (bar) doens´t exists
excel gives back an error:
ActiveChart.SeriesCollection(1).Points(3).Select in case of poínt 3
dont exists.

Is there a way to teste if the point exists, to only apply the
programing in that case?

Thanks a lot!!!

Jorge

Would something like:

ActiveChart.SeriesCollection(1).Points.Interior.ColorIndex = 3

Not work?

"SpeeD72" wrote:

> Hi.
>
> I need to apply the same color to the bars in a graph (via VBA),
> wether the graph has 3 bars or 7 bars.
>
> The problem that i face is that when the point (bar) doens´t exists
> excel gives back an error:
> ActiveChart.SeriesCollection(1).Points(3).Select in case of poÃ*nt 3
> dont exists.
>
> Is there a way to teste if the point exists, to only apply the
> programing in that case?
>
> Thanks a lot!!!
>
> Jorge
>
>

Hi.
every bar has is how color. I can make every one with the same color.

Is there a way to teste if the point exists, to only apply the
programing in that case?

Thnks
Jorge

Hi,

You can use the Count property to tell you how many points a series has.

ActiveChart.SeriesCollection(1).Points.Count

Cheers
Andy

SpeeD72 wrote:
> Hi.
> every bar has is how color. I can make every one with the same color.
>
> Is there a way to teste if the point exists, to only apply the
> programing in that case?
>
> Thnks
> Jorge
>

The code will run more smoothly if instead of using

ActiveChart.SeriesCollection(1).Points(3).Select
Selection.Interior.Blah

you use

ActiveChart.SeriesCollection(1).Points(3).Interior.Blah

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> You can use the Count property to tell you how many points a series has.
>
> ActiveChart.SeriesCollection(1).Points.Count
>
> Cheers
> Andy
>
> SpeeD72 wrote:
>> Hi.
>> every bar has is how color. I can make every one with the same color.
>>
>> Is there a way to teste if the point exists, to only apply the
>> programing in that case?
>>
>> Thnks
>> Jorge
>>