Still got a problem

[User (Legacy)]

Hi Chris!

Sorry for not posting code that did not work the other day.  Thanks for your

code.  However, I have a problem with it.  When I adapt my colouring code to

use your method, it works fine for one series but only colours half of the

graph for the 2 series.

Before I continue, I will give an explanation of what I am trying to do.  I

have an array of numbers that relate to information for a range of days.

Each day contains a number of periods (in time), in this case, night, other,

peak and Evening.  Each of these periods has its own set colour.  An

additional period, weekend, covers the weekend colour.  My colour code

colours each column in my chart according to the period of a day that the

column is relevant to.  Our system needs to take account of a varying number

of periods.  For this reason, the first of each colour is stored in a

dynamic array.

The code is attached.  I have taken as much of the code out as possible to

make it as simple as I can.  There is still a lot of code in the file that I

attach, but please note that about 75% is just needed to create the graph

and can be ignored.  I have put a "please ignore" line into the code,

anything below that line can be ignored as there is no problem with it.  I

have commented the code as well.

I used the formula that you gave me to colour the columns, as the series I

want to colour is always going to be 0 I left out the "SeriesNum+" part of

the formula.

I really hope that you or someone else can help me

Cheers

Paul

[User (Legacy)]

Sorry!  The above post was supposed to go into my previous post's group

(Problem creating a legend box)

"Paul Saxton" <paul.saxton@stcenergy.com> wrote in message

news:us#$MZ6vBHA.2668@webserver1.softwarefx.com...

> Hi Chris!

>

> Sorry for not posting code that did not work the other day.  Thanks for

your

> code.  However, I have a problem with it.  When I adapt my colouring code

to

> use your method, it works fine for one series but only colours half of the

> graph for the 2 series.

>

> Before I continue, I will give an explanation of what I am trying to do.

I

> have an array of numbers that relate to information for a range of days.

> Each day contains a number of periods (in time), in this case, night,

other,

> peak and Evening.  Each of these periods has its own set colour.  An

> additional period, weekend, covers the weekend colour.  My colour code

> colours each column in my chart according to the period of a day that the

> column is relevant to.  Our system needs to take account of a varying

number

> of periods.  For this reason, the first of each colour is stored in a

> dynamic array.

>

> The code is attached.  I have taken as much of the code out as possible to

> make it as simple as I can.  There is still a lot of code in the file that

I

> attach, but please note that about 75% is just needed to create the graph

> and can be ignored.  I have put a "please ignore" line into the code,

> anything below that line can be ignored as there is no problem with it.  I

> have commented the code as well.

>

> I used the formula that you gave me to colour the columns, as the series I

> want to colour is always going to be 0 I left out the "SeriesNum+" part of

> the formula.

>

> I really hope that you or someone else can help me

>

> Cheers

>

> Paul

>

>

>

>

>