Jump to content
Software FX Community

Data displaying incorrectly on my Gantt chart


User (Legacy)
 Share

Recommended Posts

Hi,

I'm making a Gantt chart, but seem to be having trouble getting the

information to display correctly. It's charted correctly, meaning that the

start and end times that I set are represented correctly. However, when I

mouseover each record, the series seems to be incorrect, and it's

color-coded wrong. I'll try to explain:

Here's my data (it's in XML format, so it doesn't actually look like this):

---------------

Series #1 (Represented as "Suppliers" in the code below):

Record #1 (Represented as "Rack Liftings" in the code below):

loadStartTime = "11/18/2002 8:00:00"

loadEndTime = "11/18/2002 9:00:00"

Record #2:

loadStartTime = "11/18/2002 12:00:00"

loadEndTime = "11/18/2002 13:00:00"

Series #2:

Record #1:

loadStartTime = "11/18/2002 11:00:00"

loadEndTime = "11/18/2002 12:00:00"

---------------

Here's my code (using JScript by the way...):

---------------

//loop through suppliers to build chart data

var intRackLiftingCounter = 0, intSupplierCounter = 1, numOfRackLiftings,

rackLiftingAtts;

for (x=0; x<numOfSuppliers; x++) {

//get number of rack liftings in current supplier

supplierAtts = supplierInfo.item(x).attributes;

numOfRackLiftings =

Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

Chart.Axis(2).Label(x) = "Series #" + (x+1);

//now loop through those rack lifting records

for (z=0; z<numOfRackLiftings; z++) {

rackLiftingAtts =

rackLiftingInfo.item(intRackLiftingCounter).attributes;

//set chart data

Chart.IniValueEx(x,z) =

formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

"JavaScript").getVarDate();

Chart.ValueEx(x,z) =

formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

"JavaScript").getVarDate();

intRackLiftingCounter++;

}

intSupplierCounter++;

}

---------------

Each records' "loadStartTime" and "loadEndTime" is plotted correctly,

however, the chart seems to group them into the incorrect series. So, if I

mouseover the "Series #1/Record #1" record, it says: "Series #1 From 8AM to

9AM" (which is correct). If I mouseover the "Series #2/Record #1" record,

it says "Series #1 From 11AM to 12PM" (the time is correct, but the series

number is not). Then "Series #1/Record #2" says "Series #2 From 12PM to

13PM" (the time is correct, but the series number is not).

I hope this makes sense! Do you have any ideas as to what I might be doing

wrong?

Thanks!

Chad

Link to comment
Share on other sites

The problem is that you are using the Axis legend as your series Legend when

you do:

Chart.Axis(2).Label(x) = "Series #" + (x+1);

Instead, you should do:

Chart1.Serleg(x) = "Series #" + (x+1);

The suppliers are your series, your X-Axis labels should be the number of

Rack Lifting.

If this is not what you want, then your data is being set incorrectly, when

you use:

Chart.ValueEx(x,z)

x is the Series index

z is the Point Index

A Gantt chart is drawn as <number of points> groups of <number of series>

bars. A label is displayed for each group.

I hope this all make sense to you, if you still have questions, please post

again, a screenshot of you are getting indicating what's wrong and how it

should be would be most helpful.

--

FP

Software FX Support

"Chad Lansford" <chartfx@shillglen.com> wrote in message

news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> Hi,

>

> I'm making a Gantt chart, but seem to be having trouble getting the

> information to display correctly. It's charted correctly, meaning that

the

> start and end times that I set are represented correctly. However, when I

> mouseover each record, the series seems to be incorrect, and it's

> color-coded wrong. I'll try to explain:

>

> Here's my data (it's in XML format, so it doesn't actually look like

this):

> ---------------

> Series #1 (Represented as "Suppliers" in the code below):

> Record #1 (Represented as "Rack Liftings" in the code below):

> loadStartTime = "11/18/2002 8:00:00"

> loadEndTime = "11/18/2002 9:00:00"

>

> Record #2:

> loadStartTime = "11/18/2002 12:00:00"

> loadEndTime = "11/18/2002 13:00:00"

>

> Series #2:

> Record #1:

> loadStartTime = "11/18/2002 11:00:00"

> loadEndTime = "11/18/2002 12:00:00"

> ---------------

>

> Here's my code (using JScript by the way...):

> ---------------

> //loop through suppliers to build chart data

> var intRackLiftingCounter = 0, intSupplierCounter = 1, numOfRackLiftings,

> rackLiftingAtts;

> for (x=0; x<numOfSuppliers; x++) {

> //get number of rack liftings in current supplier

> supplierAtts = supplierInfo.item(x).attributes;

> numOfRackLiftings =

> Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> Chart.Axis(2).Label(x) = "Series #" + (x+1);

>

> //now loop through those rack lifting records

> for (z=0; z<numOfRackLiftings; z++) {

> rackLiftingAtts =

> rackLiftingInfo.item(intRackLiftingCounter).attributes;

> //set chart data

> Chart.IniValueEx(x,z) =

> formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> "JavaScript").getVarDate();

> Chart.ValueEx(x,z) =

> formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> "JavaScript").getVarDate();

> intRackLiftingCounter++;

> }

> intSupplierCounter++;

> }

> ---------------

>

> Each records' "loadStartTime" and "loadEndTime" is plotted correctly,

> however, the chart seems to group them into the incorrect series. So, if

I

> mouseover the "Series #1/Record #1" record, it says: "Series #1 From 8AM

to

> 9AM" (which is correct). If I mouseover the "Series #2/Record #1" record,

> it says "Series #1 From 11AM to 12PM" (the time is correct, but the series

> number is not). Then "Series #1/Record #2" says "Series #2 From 12PM to

> 13PM" (the time is correct, but the series number is not).

>

> I hope this makes sense! Do you have any ideas as to what I might be

doing

> wrong?

>

> Thanks!

> Chad

>

>

Link to comment
Share on other sites

Thanks for your response!!  Unfortunately, I'm still having problems.

Here's some screen shots with descriptions in them.

The first one (gantt_current.gif) shows how the chart is displaying right

now, and the descriptions in the image tell what is wrong with it. The

second one (gantt_fixed.gif) shows how I want it to display. Here's the

exact data (in XML format) that I'm using:

----------------------------------------------------------------------------

------

<apiResult errorCode="0" errorDesc="Ok" diagnose="0">

<getRackLiftingsResult

shiftStart="2002-11-18T06:00:00"

shiftEnd="2002-11-18T18:00:00"

numOfSuppliers="2"

>

<supplier

numOfRackLiftings="2"

>

<rackLifting

loadStartTime="2002-11-18T08:00:00"

loadEndTime="2002-11-18T09:00:00"

/>

<rackLifting

loadStartTime="2002-11-18T09:00:00"

loadEndTime="2002-11-18T10:00:00"

/>

</supplier>

<supplier

numOfRackLiftings="1"

>

<rackLifting

loadStartTime="2002-11-18T11:00:00"

loadEndTime="2002-11-18T12:00:00"

/>

</supplier>

</getRackLiftingsResult>

</apiResult>

----------------------------------------------------------------------------

------

Thanks for all the help!!

Chad

"Software FX Support" <support@softwarefx.com> wrote in message

news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> The problem is that you are using the Axis legend as your series Legend

when

> you do:

>

> Chart.Axis(2).Label(x) = "Series #" + (x+1);

>

> Instead, you should do:

>

> Chart1.Serleg(x) = "Series #" + (x+1);

>

> The suppliers are your series, your X-Axis labels should be the number of

> Rack Lifting.

>

> If this is not what you want, then your data is being set incorrectly,

when

> you use:

>

> Chart.ValueEx(x,z)

>

> x is the Series index

> z is the Point Index

>

> A Gantt chart is drawn as <number of points> groups of <number of series>

> bars. A label is displayed for each group.

>

> I hope this all make sense to you, if you still have questions, please

post

> again, a screenshot of you are getting indicating what's wrong and how it

> should be would be most helpful.

>

> --

> FP

> Software FX Support

> "Chad Lansford" <chartfx@shillglen.com> wrote in message

> news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > Hi,

> >

> > I'm making a Gantt chart, but seem to be having trouble getting the

> > information to display correctly. It's charted correctly, meaning that

> the

> > start and end times that I set are represented correctly. However, when

I

> > mouseover each record, the series seems to be incorrect, and it's

> > color-coded wrong. I'll try to explain:

> >

> > Here's my data (it's in XML format, so it doesn't actually look like

> this):

> > ---------------

> > Series #1 (Represented as "Suppliers" in the code below):

> > Record #1 (Represented as "Rack Liftings" in the code below):

> > loadStartTime = "11/18/2002 8:00:00"

> > loadEndTime = "11/18/2002 9:00:00"

> >

> > Record #2:

> > loadStartTime = "11/18/2002 12:00:00"

> > loadEndTime = "11/18/2002 13:00:00"

> >

> > Series #2:

> > Record #1:

> > loadStartTime = "11/18/2002 11:00:00"

> > loadEndTime = "11/18/2002 12:00:00"

> > ---------------

> >

> > Here's my code (using JScript by the way...):

> > ---------------

> > //loop through suppliers to build chart data

> > var intRackLiftingCounter = 0, intSupplierCounter = 1,

numOfRackLiftings,

> > rackLiftingAtts;

> > for (x=0; x<numOfSuppliers; x++) {

> > //get number of rack liftings in current supplier

> > supplierAtts = supplierInfo.item(x).attributes;

> > numOfRackLiftings =

> > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> >

> > //now loop through those rack lifting records

> > for (z=0; z<numOfRackLiftings; z++) {

> > rackLiftingAtts =

> > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > //set chart data

> > Chart.IniValueEx(x,z) =

> > formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > "JavaScript").getVarDate();

> > Chart.ValueEx(x,z) =

> > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > "JavaScript").getVarDate();

> > intRackLiftingCounter++;

> > }

> > intSupplierCounter++;

> > }

> > ---------------

> >

> > Each records' "loadStartTime" and "loadEndTime" is plotted correctly,

> > however, the chart seems to group them into the incorrect series. So,

if

> I

> > mouseover the "Series #1/Record #1" record, it says: "Series #1 From 8AM

> to

> > 9AM" (which is correct). If I mouseover the "Series #2/Record #1"

record,

> > it says "Series #1 From 11AM to 12PM" (the time is correct, but the

series

> > number is not). Then "Series #1/Record #2" says "Series #2 From 12PM to

> > 13PM" (the time is correct, but the series number is not).

> >

> > I hope this makes sense! Do you have any ideas as to what I might be

> doing

> > wrong?

> >

> > Thanks!

> > Chad

> >

> >

>

>

Link to comment
Share on other sites

I think the problem comes from the misunderstanding on how data is stored in

Chart FX.

The data in Chart FX is a table of rows and columns, all rows and column are

the SAME SIZE.

The data that is showing up without being set is just being initialized to

its default value (zero). To give you a better understanding on how the data

is stored in the chart, you may turn on the Data Editor (DataEditor = true).

The second problem is that you are thinking that the labels on the left side

are the series. They are not. What you see in the left side are the X-Axis

labels. Do not refer to them as series, series are the blue and the red and

they can be together in the same group.

To create a chart like the one you want is not trivial, as you want multiple

instances of the same color within the same group, namely the 2 blue bars at

the bottom of your chart.

Lets forget about the color for a second (I'll come back to that later). To

obtain this chart your data has to be passed as follows:

IniValueEx(0,0) = 8A

ValueEx(0,0) = 9A

IniValueEx(1,0) = 9A

ValueEx(1,0) = 10A

IniValueEx(0,1) = 11A

ValueEx(0,1) = 12P

IniValueEx(1,1) = 0

ValueEx(1,1) = CHART_HIDDEN

If this is not clear enough. This is how the data needs to go into the chart

to get what you want. If you are passing an XML to Chart FX I'll be happy to

show you how it should be rearranged.

After this you will obtain a chart similar to the one you want but the

colors will be different. Check out the following KB article that shows you

how to assign colors individually.

Q1371002. Changing the colors of the markers depending on a condition

--

FP

Software FX Support

"Chad Lansford" <chartfx@shillglen.com> wrote in message

news:NAXmBxfpCHA.2284@webserver1.softwarefx.com...

> Thanks for your response!! Unfortunately, I'm still having problems.

> Here's some screen shots with descriptions in them.

>

> The first one (gantt_current.gif) shows how the chart is displaying right

> now, and the descriptions in the image tell what is wrong with it. The

> second one (gantt_fixed.gif) shows how I want it to display. Here's the

> exact data (in XML format) that I'm using:

>

> --------------------------------------------------------------------------

--

> ------

> <apiResult errorCode="0" errorDesc="Ok" diagnose="0">

> <getRackLiftingsResult

> shiftStart="2002-11-18T06:00:00"

> shiftEnd="2002-11-18T18:00:00"

> numOfSuppliers="2"

> >

> <supplier

> numOfRackLiftings="2"

> >

> <rackLifting

> loadStartTime="2002-11-18T08:00:00"

> loadEndTime="2002-11-18T09:00:00"

> />

> <rackLifting

> loadStartTime="2002-11-18T09:00:00"

> loadEndTime="2002-11-18T10:00:00"

> />

> </supplier>

> <supplier

> numOfRackLiftings="1"

> >

> <rackLifting

> loadStartTime="2002-11-18T11:00:00"

> loadEndTime="2002-11-18T12:00:00"

> />

> </supplier>

> </getRackLiftingsResult>

> </apiResult>

> --------------------------------------------------------------------------

--

> ------

>

> Thanks for all the help!!

> Chad

>

>

>

> "Software FX Support" <support@softwarefx.com> wrote in message

> news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> > The problem is that you are using the Axis legend as your series Legend

> when

> > you do:

> >

> > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> >

> > Instead, you should do:

> >

> > Chart1.Serleg(x) = "Series #" + (x+1);

> >

> > The suppliers are your series, your X-Axis labels should be the number

of

> > Rack Lifting.

> >

> > If this is not what you want, then your data is being set incorrectly,

> when

> > you use:

> >

> > Chart.ValueEx(x,z)

> >

> > x is the Series index

> > z is the Point Index

> >

> > A Gantt chart is drawn as <number of points> groups of <number of

series>

> > bars. A label is displayed for each group.

> >

> > I hope this all make sense to you, if you still have questions, please

> post

> > again, a screenshot of you are getting indicating what's wrong and how

it

> > should be would be most helpful.

> >

> > --

> > FP

> > Software FX Support

> > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > > Hi,

> > >

> > > I'm making a Gantt chart, but seem to be having trouble getting the

> > > information to display correctly. It's charted correctly, meaning

that

> > the

> > > start and end times that I set are represented correctly. However,

when

> I

> > > mouseover each record, the series seems to be incorrect, and it's

> > > color-coded wrong. I'll try to explain:

> > >

> > > Here's my data (it's in XML format, so it doesn't actually look like

> > this):

> > > ---------------

> > > Series #1 (Represented as "Suppliers" in the code below):

> > > Record #1 (Represented as "Rack Liftings" in the code below):

> > > loadStartTime = "11/18/2002 8:00:00"

> > > loadEndTime = "11/18/2002 9:00:00"

> > >

> > > Record #2:

> > > loadStartTime = "11/18/2002 12:00:00"

> > > loadEndTime = "11/18/2002 13:00:00"

> > >

> > > Series #2:

> > > Record #1:

> > > loadStartTime = "11/18/2002 11:00:00"

> > > loadEndTime = "11/18/2002 12:00:00"

> > > ---------------

> > >

> > > Here's my code (using JScript by the way...):

> > > ---------------

> > > //loop through suppliers to build chart data

> > > var intRackLiftingCounter = 0, intSupplierCounter = 1,

> numOfRackLiftings,

> > > rackLiftingAtts;

> > > for (x=0; x<numOfSuppliers; x++) {

> > > //get number of rack liftings in current supplier

> > > supplierAtts = supplierInfo.item(x).attributes;

> > > numOfRackLiftings =

> > > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > >

> > > //now loop through those rack lifting records

> > > for (z=0; z<numOfRackLiftings; z++) {

> > > rackLiftingAtts =

> > > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > > //set chart data

> > > Chart.IniValueEx(x,z) =

> > > formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > > "JavaScript").getVarDate();

> > > Chart.ValueEx(x,z) =

> > > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > > "JavaScript").getVarDate();

> > > intRackLiftingCounter++;

> > > }

> > > intSupplierCounter++;

> > > }

> > > ---------------

> > >

> > > Each records' "loadStartTime" and "loadEndTime" is plotted correctly,

> > > however, the chart seems to group them into the incorrect series. So,

> if

> > I

> > > mouseover the "Series #1/Record #1" record, it says: "Series #1 From

8AM

> > to

> > > 9AM" (which is correct). If I mouseover the "Series #2/Record #1"

> record,

> > > it says "Series #1 From 11AM to 12PM" (the time is correct, but the

> series

> > > number is not). Then "Series #1/Record #2" says "Series #2 From 12PM

to

> > > 13PM" (the time is correct, but the series number is not).

> > >

> > > I hope this makes sense! Do you have any ideas as to what I might be

> > doing

> > > wrong?

> > >

> > > Thanks!

> > > Chad

> > >

> > >

> >

> >

>

>

>

post-2107-13922389596209_thumb.gif

Link to comment
Share on other sites

Thanks!  The data is not displaying correctly.   HOWEVER, I can't get the

colors to display correctly, I read the article that you told me about, but

it only gives instructions on how to set the color for a "Series". Since

the "Series" on my gantt chart does not represent the X-Axis data, any color

settings I make are still showing incorrectly. Is there any way to set the

color for each and every single point on the chart individually?? If there

is, I can't seem to find it in the documentation.

Thanks,

Chad

"Software FX Support" <support@softwarefx.com> wrote in message

news:eSlKyjhpCHA.2684@webserver1.softwarefx.com...

> I think the problem comes from the misunderstanding on how data is stored

in

> Chart FX.

>

> The data in Chart FX is a table of rows and columns, all rows and column

are

> the SAME SIZE.

>

> The data that is showing up without being set is just being initialized to

> its default value (zero). To give you a better understanding on how the

data

> is stored in the chart, you may turn on the Data Editor (DataEditor =

true).

>

> The second problem is that you are thinking that the labels on the left

side

> are the series. They are not. What you see in the left side are the X-Axis

> labels. Do not refer to them as series, series are the blue and the red

and

> they can be together in the same group.

>

> To create a chart like the one you want is not trivial, as you want

multiple

> instances of the same color within the same group, namely the 2 blue bars

at

> the bottom of your chart.

>

> Lets forget about the color for a second (I'll come back to that later).

To

> obtain this chart your data has to be passed as follows:

>

> IniValueEx(0,0) = 8A

> ValueEx(0,0) = 9A

> IniValueEx(1,0) = 9A

> ValueEx(1,0) = 10A

> IniValueEx(0,1) = 11A

> ValueEx(0,1) = 12P

> IniValueEx(1,1) = 0

> ValueEx(1,1) = CHART_HIDDEN

>

> If this is not clear enough. This is how the data needs to go into the

chart

> to get what you want. If you are passing an XML to Chart FX I'll be happy

to

> show you how it should be rearranged.

>

> After this you will obtain a chart similar to the one you want but the

> colors will be different. Check out the following KB article that shows

you

> how to assign colors individually.

>

> Q1371002. Changing the colors of the markers depending on a condition

>

> --

> FP

> Software FX Support

> "Chad Lansford" <chartfx@shillglen.com> wrote in message

> news:NAXmBxfpCHA.2284@webserver1.softwarefx.com...

> > Thanks for your response!! Unfortunately, I'm still having problems.

> > Here's some screen shots with descriptions in them.

> >

> > The first one (gantt_current.gif) shows how the chart is displaying

right

> > now, and the descriptions in the image tell what is wrong with it. The

> > second one (gantt_fixed.gif) shows how I want it to display. Here's the

> > exact data (in XML format) that I'm using:

> >

>

> --------------------------------------------------------------------------

> --

> > ------

> > <apiResult errorCode="0" errorDesc="Ok" diagnose="0">

> > <getRackLiftingsResult

> > shiftStart="2002-11-18T06:00:00"

> > shiftEnd="2002-11-18T18:00:00"

> > numOfSuppliers="2"

> > >

> > <supplier

> > numOfRackLiftings="2"

> > >

> > <rackLifting

> > loadStartTime="2002-11-18T08:00:00"

> > loadEndTime="2002-11-18T09:00:00"

> > />

> > <rackLifting

> > loadStartTime="2002-11-18T09:00:00"

> > loadEndTime="2002-11-18T10:00:00"

> > />

> > </supplier>

> > <supplier

> > numOfRackLiftings="1"

> > >

> > <rackLifting

> > loadStartTime="2002-11-18T11:00:00"

> > loadEndTime="2002-11-18T12:00:00"

> > />

> > </supplier>

> > </getRackLiftingsResult>

> > </apiResult>

>

> --------------------------------------------------------------------------

> --

> > ------

> >

> > Thanks for all the help!!

> > Chad

> >

> >

> >

> > "Software FX Support" <support@softwarefx.com> wrote in message

> > news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> > > The problem is that you are using the Axis legend as your series

Legend

> > when

> > > you do:

> > >

> > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > >

> > > Instead, you should do:

> > >

> > > Chart1.Serleg(x) = "Series #" + (x+1);

> > >

> > > The suppliers are your series, your X-Axis labels should be the number

> of

> > > Rack Lifting.

> > >

> > > If this is not what you want, then your data is being set incorrectly,

> > when

> > > you use:

> > >

> > > Chart.ValueEx(x,z)

> > >

> > > x is the Series index

> > > z is the Point Index

> > >

> > > A Gantt chart is drawn as <number of points> groups of <number of

> series>

> > > bars. A label is displayed for each group.

> > >

> > > I hope this all make sense to you, if you still have questions, please

> > post

> > > again, a screenshot of you are getting indicating what's wrong and how

> it

> > > should be would be most helpful.

> > >

> > > --

> > > FP

> > > Software FX Support

> > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > > > Hi,

> > > >

> > > > I'm making a Gantt chart, but seem to be having trouble getting the

> > > > information to display correctly. It's charted correctly, meaning

> that

> > > the

> > > > start and end times that I set are represented correctly. However,

> when

> > I

> > > > mouseover each record, the series seems to be incorrect, and it's

> > > > color-coded wrong. I'll try to explain:

> > > >

> > > > Here's my data (it's in XML format, so it doesn't actually look like

> > > this):

> > > > ---------------

> > > > Series #1 (Represented as "Suppliers" in the code below):

> > > > Record #1 (Represented as "Rack Liftings" in the code below):

> > > > loadStartTime = "11/18/2002 8:00:00"

> > > > loadEndTime = "11/18/2002 9:00:00"

> > > >

> > > > Record #2:

> > > > loadStartTime = "11/18/2002 12:00:00"

> > > > loadEndTime = "11/18/2002 13:00:00"

> > > >

> > > > Series #2:

> > > > Record #1:

> > > > loadStartTime = "11/18/2002 11:00:00"

> > > > loadEndTime = "11/18/2002 12:00:00"

> > > > ---------------

> > > >

> > > > Here's my code (using JScript by the way...):

> > > > ---------------

> > > > //loop through suppliers to build chart data

> > > > var intRackLiftingCounter = 0, intSupplierCounter = 1,

> > numOfRackLiftings,

> > > > rackLiftingAtts;

> > > > for (x=0; x<numOfSuppliers; x++) {

> > > > //get number of rack liftings in current supplier

> > > > supplierAtts = supplierInfo.item(x).attributes;

> > > > numOfRackLiftings =

> > > > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > >

> > > > //now loop through those rack lifting records

> > > > for (z=0; z<numOfRackLiftings; z++) {

> > > > rackLiftingAtts =

> > > > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > > > //set chart data

> > > > Chart.IniValueEx(x,z) =

> > > > formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > > > "JavaScript").getVarDate();

> > > > Chart.ValueEx(x,z) =

> > > > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > > > "JavaScript").getVarDate();

> > > > intRackLiftingCounter++;

> > > > }

> > > > intSupplierCounter++;

> > > > }

> > > > ---------------

> > > >

> > > > Each records' "loadStartTime" and "loadEndTime" is plotted

correctly,

> > > > however, the chart seems to group them into the incorrect series.

So,

> > if

> > > I

> > > > mouseover the "Series #1/Record #1" record, it says: "Series #1 From

> 8AM

> > > to

> > > > 9AM" (which is correct). If I mouseover the "Series #2/Record #1"

> > record,

> > > > it says "Series #1 From 11AM to 12PM" (the time is correct, but the

> > series

> > > > number is not). Then "Series #1/Record #2" says "Series #2 From

12PM

> to

> > > > 13PM" (the time is correct, but the series number is not).

> > > >

> > > > I hope this makes sense! Do you have any ideas as to what I might

be

> > > doing

> > > > wrong?

> > > >

> > > > Thanks!

> > > > Chad

> > > >

> > > >

> > >

> > >

> >

> >

> >

>

>

Link to comment
Share on other sites

Correction:  The data IS displaying correctly, but the colors are not...

Sorry,

Chad

"Chad Lansford" <chartfx@shillglen.com> wrote in message

news:$26hffipCHA.2684@webserver1.softwarefx.com...

> Thanks! The data is not displaying correctly. HOWEVER, I can't get the

> colors to display correctly, I read the article that you told me about,

but

> it only gives instructions on how to set the color for a "Series". Since

> the "Series" on my gantt chart does not represent the X-Axis data, any

color

> settings I make are still showing incorrectly. Is there any way to set

the

> color for each and every single point on the chart individually?? If

there

> is, I can't seem to find it in the documentation.

>

> Thanks,

> Chad

>

>

> "Software FX Support" <support@softwarefx.com> wrote in message

> news:eSlKyjhpCHA.2684@webserver1.softwarefx.com...

> > I think the problem comes from the misunderstanding on how data is

stored

> in

> > Chart FX.

> >

> > The data in Chart FX is a table of rows and columns, all rows and column

> are

> > the SAME SIZE.

> >

> > The data that is showing up without being set is just being initialized

to

> > its default value (zero). To give you a better understanding on how the

> data

> > is stored in the chart, you may turn on the Data Editor (DataEditor =

> true).

> >

> > The second problem is that you are thinking that the labels on the left

> side

> > are the series. They are not. What you see in the left side are the

X-Axis

> > labels. Do not refer to them as series, series are the blue and the red

> and

> > they can be together in the same group.

> >

> > To create a chart like the one you want is not trivial, as you want

> multiple

> > instances of the same color within the same group, namely the 2 blue

bars

> at

> > the bottom of your chart.

> >

> > Lets forget about the color for a second (I'll come back to that later).

> To

> > obtain this chart your data has to be passed as follows:

> >

> > IniValueEx(0,0) = 8A

> > ValueEx(0,0) = 9A

> > IniValueEx(1,0) = 9A

> > ValueEx(1,0) = 10A

> > IniValueEx(0,1) = 11A

> > ValueEx(0,1) = 12P

> > IniValueEx(1,1) = 0

> > ValueEx(1,1) = CHART_HIDDEN

> >

> > If this is not clear enough. This is how the data needs to go into the

> chart

> > to get what you want. If you are passing an XML to Chart FX I'll be

happy

> to

> > show you how it should be rearranged.

> >

> > After this you will obtain a chart similar to the one you want but the

> > colors will be different. Check out the following KB article that shows

> you

> > how to assign colors individually.

> >

> > Q1371002. Changing the colors of the markers depending on a condition

> >

> > --

> > FP

> > Software FX Support

> > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > news:NAXmBxfpCHA.2284@webserver1.softwarefx.com...

> > > Thanks for your response!! Unfortunately, I'm still having problems.

> > > Here's some screen shots with descriptions in them.

> > >

> > > The first one (gantt_current.gif) shows how the chart is displaying

> right

> > > now, and the descriptions in the image tell what is wrong with it.

The

> > > second one (gantt_fixed.gif) shows how I want it to display. Here's

the

> > > exact data (in XML format) that I'm using:

> > >

> >

>

> --------------------------------------------------------------------------

> > --

> > > ------

> > > <apiResult errorCode="0" errorDesc="Ok" diagnose="0">

> > > <getRackLiftingsResult

> > > shiftStart="2002-11-18T06:00:00"

> > > shiftEnd="2002-11-18T18:00:00"

> > > numOfSuppliers="2"

> > > >

> > > <supplier

> > > numOfRackLiftings="2"

> > > >

> > > <rackLifting

> > > loadStartTime="2002-11-18T08:00:00"

> > > loadEndTime="2002-11-18T09:00:00"

> > > />

> > > <rackLifting

> > > loadStartTime="2002-11-18T09:00:00"

> > > loadEndTime="2002-11-18T10:00:00"

> > > />

> > > </supplier>

> > > <supplier

> > > numOfRackLiftings="1"

> > > >

> > > <rackLifting

> > > loadStartTime="2002-11-18T11:00:00"

> > > loadEndTime="2002-11-18T12:00:00"

> > > />

> > > </supplier>

> > > </getRackLiftingsResult>

> > > </apiResult>

> >

>

> --------------------------------------------------------------------------

> > --

> > > ------

> > >

> > > Thanks for all the help!!

> > > Chad

> > >

> > >

> > >

> > > "Software FX Support" <support@softwarefx.com> wrote in message

> > > news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> > > > The problem is that you are using the Axis legend as your series

> Legend

> > > when

> > > > you do:

> > > >

> > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > >

> > > > Instead, you should do:

> > > >

> > > > Chart1.Serleg(x) = "Series #" + (x+1);

> > > >

> > > > The suppliers are your series, your X-Axis labels should be the

number

> > of

> > > > Rack Lifting.

> > > >

> > > > If this is not what you want, then your data is being set

incorrectly,

> > > when

> > > > you use:

> > > >

> > > > Chart.ValueEx(x,z)

> > > >

> > > > x is the Series index

> > > > z is the Point Index

> > > >

> > > > A Gantt chart is drawn as <number of points> groups of <number of

> > series>

> > > > bars. A label is displayed for each group.

> > > >

> > > > I hope this all make sense to you, if you still have questions,

please

> > > post

> > > > again, a screenshot of you are getting indicating what's wrong and

how

> > it

> > > > should be would be most helpful.

> > > >

> > > > --

> > > > FP

> > > > Software FX Support

> > > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > > news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > > > > Hi,

> > > > >

> > > > > I'm making a Gantt chart, but seem to be having trouble getting

the

> > > > > information to display correctly. It's charted correctly, meaning

> > that

> > > > the

> > > > > start and end times that I set are represented correctly.

However,

> > when

> > > I

> > > > > mouseover each record, the series seems to be incorrect, and it's

> > > > > color-coded wrong. I'll try to explain:

> > > > >

> > > > > Here's my data (it's in XML format, so it doesn't actually look

like

> > > > this):

> > > > > ---------------

> > > > > Series #1 (Represented as "Suppliers" in the code below):

> > > > > Record #1 (Represented as "Rack Liftings" in the code below):

> > > > > loadStartTime = "11/18/2002 8:00:00"

> > > > > loadEndTime = "11/18/2002 9:00:00"

> > > > >

> > > > > Record #2:

> > > > > loadStartTime = "11/18/2002 12:00:00"

> > > > > loadEndTime = "11/18/2002 13:00:00"

> > > > >

> > > > > Series #2:

> > > > > Record #1:

> > > > > loadStartTime = "11/18/2002 11:00:00"

> > > > > loadEndTime = "11/18/2002 12:00:00"

> > > > > ---------------

> > > > >

> > > > > Here's my code (using JScript by the way...):

> > > > > ---------------

> > > > > //loop through suppliers to build chart data

> > > > > var intRackLiftingCounter = 0, intSupplierCounter = 1,

> > > numOfRackLiftings,

> > > > > rackLiftingAtts;

> > > > > for (x=0; x<numOfSuppliers; x++) {

> > > > > //get number of rack liftings in current supplier

> > > > > supplierAtts = supplierInfo.item(x).attributes;

> > > > > numOfRackLiftings =

> > > > > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > > >

> > > > > //now loop through those rack lifting records

> > > > > for (z=0; z<numOfRackLiftings; z++) {

> > > > > rackLiftingAtts =

> > > > > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > > > > //set chart data

> > > > > Chart.IniValueEx(x,z) =

> > > > > formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > > > > "JavaScript").getVarDate();

> > > > > Chart.ValueEx(x,z) =

> > > > > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > > > > "JavaScript").getVarDate();

> > > > > intRackLiftingCounter++;

> > > > > }

> > > > > intSupplierCounter++;

> > > > > }

> > > > > ---------------

> > > > >

> > > > > Each records' "loadStartTime" and "loadEndTime" is plotted

> correctly,

> > > > > however, the chart seems to group them into the incorrect series.

> So,

> > > if

> > > > I

> > > > > mouseover the "Series #1/Record #1" record, it says: "Series #1

From

> > 8AM

> > > > to

> > > > > 9AM" (which is correct). If I mouseover the "Series #2/Record #1"

> > > record,

> > > > > it says "Series #1 From 11AM to 12PM" (the time is correct, but

the

> > > series

> > > > > number is not). Then "Series #1/Record #2" says "Series #2 From

> 12PM

> > to

> > > > > 13PM" (the time is correct, but the series number is not).

> > > > >

> > > > > I hope this makes sense! Do you have any ideas as to what I might

> be

> > > > doing

> > > > > wrong?

> > > > >

> > > > > Thanks!

> > > > > Chad

> > > > >

> > > > >

> > > >

> > > >

> > >

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

Anyone?  Anyone???

Thanks,

Chad

"Chad Lansford" <chartfx@shillglen.com> wrote in message

news:wVH8YhipCHA.2684@webserver1.softwarefx.com...

> Correction: The data IS displaying correctly, but the colors are not...

>

> Sorry,

> Chad

>

> "Chad Lansford" <chartfx@shillglen.com> wrote in message

> news:$26hffipCHA.2684@webserver1.softwarefx.com...

> > Thanks! The data is not displaying correctly. HOWEVER, I can't get

the

> > colors to display correctly, I read the article that you told me about,

> but

> > it only gives instructions on how to set the color for a "Series".

Since

> > the "Series" on my gantt chart does not represent the X-Axis data, any

> color

> > settings I make are still showing incorrectly. Is there any way to set

> the

> > color for each and every single point on the chart individually?? If

> there

> > is, I can't seem to find it in the documentation.

> >

> > Thanks,

> > Chad

> >

> >

> > "Software FX Support" <support@softwarefx.com> wrote in message

> > news:eSlKyjhpCHA.2684@webserver1.softwarefx.com...

> > > I think the problem comes from the misunderstanding on how data is

> stored

> > in

> > > Chart FX.

> > >

> > > The data in Chart FX is a table of rows and columns, all rows and

column

> > are

> > > the SAME SIZE.

> > >

> > > The data that is showing up without being set is just being

initialized

> to

> > > its default value (zero). To give you a better understanding on how

the

> > data

> > > is stored in the chart, you may turn on the Data Editor (DataEditor =

> > true).

> > >

> > > The second problem is that you are thinking that the labels on the

left

> > side

> > > are the series. They are not. What you see in the left side are the

> X-Axis

> > > labels. Do not refer to them as series, series are the blue and the

red

> > and

> > > they can be together in the same group.

> > >

> > > To create a chart like the one you want is not trivial, as you want

> > multiple

> > > instances of the same color within the same group, namely the 2 blue

> bars

> > at

> > > the bottom of your chart.

> > >

> > > Lets forget about the color for a second (I'll come back to that

later).

> > To

> > > obtain this chart your data has to be passed as follows:

> > >

> > > IniValueEx(0,0) = 8A

> > > ValueEx(0,0) = 9A

> > > IniValueEx(1,0) = 9A

> > > ValueEx(1,0) = 10A

> > > IniValueEx(0,1) = 11A

> > > ValueEx(0,1) = 12P

> > > IniValueEx(1,1) = 0

> > > ValueEx(1,1) = CHART_HIDDEN

> > >

> > > If this is not clear enough. This is how the data needs to go into the

> > chart

> > > to get what you want. If you are passing an XML to Chart FX I'll be

> happy

> > to

> > > show you how it should be rearranged.

> > >

> > > After this you will obtain a chart similar to the one you want but the

> > > colors will be different. Check out the following KB article that

shows

> > you

> > > how to assign colors individually.

> > >

> > > Q1371002. Changing the colors of the markers depending on a condition

> > >

> > > --

> > > FP

> > > Software FX Support

> > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > news:NAXmBxfpCHA.2284@webserver1.softwarefx.com...

> > > > Thanks for your response!! Unfortunately, I'm still having

problems.

> > > > Here's some screen shots with descriptions in them.

> > > >

> > > > The first one (gantt_current.gif) shows how the chart is displaying

> > right

> > > > now, and the descriptions in the image tell what is wrong with it.

> The

> > > > second one (gantt_fixed.gif) shows how I want it to display. Here's

> the

> > > > exact data (in XML format) that I'm using:

> > > >

> > >

> >

>

> --------------------------------------------------------------------------

> > > --

> > > > ------

> > > > <apiResult errorCode="0" errorDesc="Ok" diagnose="0">

> > > > <getRackLiftingsResult

> > > > shiftStart="2002-11-18T06:00:00"

> > > > shiftEnd="2002-11-18T18:00:00"

> > > > numOfSuppliers="2"

> > > > >

> > > > <supplier

> > > > numOfRackLiftings="2"

> > > > >

> > > > <rackLifting

> > > > loadStartTime="2002-11-18T08:00:00"

> > > > loadEndTime="2002-11-18T09:00:00"

> > > > />

> > > > <rackLifting

> > > > loadStartTime="2002-11-18T09:00:00"

> > > > loadEndTime="2002-11-18T10:00:00"

> > > > />

> > > > </supplier>

> > > > <supplier

> > > > numOfRackLiftings="1"

> > > > >

> > > > <rackLifting

> > > > loadStartTime="2002-11-18T11:00:00"

> > > > loadEndTime="2002-11-18T12:00:00"

> > > > />

> > > > </supplier>

> > > > </getRackLiftingsResult>

> > > > </apiResult>

> > >

> >

>

> --------------------------------------------------------------------------

> > > --

> > > > ------

> > > >

> > > > Thanks for all the help!!

> > > > Chad

> > > >

> > > >

> > > >

> > > > "Software FX Support" <support@softwarefx.com> wrote in message

> > > > news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> > > > > The problem is that you are using the Axis legend as your series

> > Legend

> > > > when

> > > > > you do:

> > > > >

> > > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > > >

> > > > > Instead, you should do:

> > > > >

> > > > > Chart1.Serleg(x) = "Series #" + (x+1);

> > > > >

> > > > > The suppliers are your series, your X-Axis labels should be the

> number

> > > of

> > > > > Rack Lifting.

> > > > >

> > > > > If this is not what you want, then your data is being set

> incorrectly,

> > > > when

> > > > > you use:

> > > > >

> > > > > Chart.ValueEx(x,z)

> > > > >

> > > > > x is the Series index

> > > > > z is the Point Index

> > > > >

> > > > > A Gantt chart is drawn as <number of points> groups of <number of

> > > series>

> > > > > bars. A label is displayed for each group.

> > > > >

> > > > > I hope this all make sense to you, if you still have questions,

> please

> > > > post

> > > > > again, a screenshot of you are getting indicating what's wrong and

> how

> > > it

> > > > > should be would be most helpful.

> > > > >

> > > > > --

> > > > > FP

> > > > > Software FX Support

> > > > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > > > news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > > > > > Hi,

> > > > > >

> > > > > > I'm making a Gantt chart, but seem to be having trouble getting

> the

> > > > > > information to display correctly. It's charted correctly,

meaning

> > > that

> > > > > the

> > > > > > start and end times that I set are represented correctly.

> However,

> > > when

> > > > I

> > > > > > mouseover each record, the series seems to be incorrect, and

it's

> > > > > > color-coded wrong. I'll try to explain:

> > > > > >

> > > > > > Here's my data (it's in XML format, so it doesn't actually look

> like

> > > > > this):

> > > > > > ---------------

> > > > > > Series #1 (Represented as "Suppliers" in the code below):

> > > > > > Record #1 (Represented as "Rack Liftings" in the code

below):

> > > > > > loadStartTime = "11/18/2002 8:00:00"

> > > > > > loadEndTime = "11/18/2002 9:00:00"

> > > > > >

> > > > > > Record #2:

> > > > > > loadStartTime = "11/18/2002 12:00:00"

> > > > > > loadEndTime = "11/18/2002 13:00:00"

> > > > > >

> > > > > > Series #2:

> > > > > > Record #1:

> > > > > > loadStartTime = "11/18/2002 11:00:00"

> > > > > > loadEndTime = "11/18/2002 12:00:00"

> > > > > > ---------------

> > > > > >

> > > > > > Here's my code (using JScript by the way...):

> > > > > > ---------------

> > > > > > //loop through suppliers to build chart data

> > > > > > var intRackLiftingCounter = 0, intSupplierCounter = 1,

> > > > numOfRackLiftings,

> > > > > > rackLiftingAtts;

> > > > > > for (x=0; x<numOfSuppliers; x++) {

> > > > > > //get number of rack liftings in current supplier

> > > > > > supplierAtts = supplierInfo.item(x).attributes;

> > > > > > numOfRackLiftings =

> > > > > > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > > > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > > > >

> > > > > > //now loop through those rack lifting records

> > > > > > for (z=0; z<numOfRackLiftings; z++) {

> > > > > > rackLiftingAtts =

> > > > > > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > > > > > //set chart data

> > > > > > Chart.IniValueEx(x,z) =

> > > > > > formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > > > > > "JavaScript").getVarDate();

> > > > > > Chart.ValueEx(x,z) =

> > > > > > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > > > > > "JavaScript").getVarDate();

> > > > > > intRackLiftingCounter++;

> > > > > > }

> > > > > > intSupplierCounter++;

> > > > > > }

> > > > > > ---------------

> > > > > >

> > > > > > Each records' "loadStartTime" and "loadEndTime" is plotted

> > correctly,

> > > > > > however, the chart seems to group them into the incorrect

series.

> > So,

> > > > if

> > > > > I

> > > > > > mouseover the "Series #1/Record #1" record, it says: "Series #1

> From

> > > 8AM

> > > > > to

> > > > > > 9AM" (which is correct). If I mouseover the "Series #2/Record

#1"

> > > > record,

> > > > > > it says "Series #1 From 11AM to 12PM" (the time is correct, but

> the

> > > > series

> > > > > > number is not). Then "Series #1/Record #2" says "Series #2 From

> > 12PM

> > > to

> > > > > > 13PM" (the time is correct, but the series number is not).

> > > > > >

> > > > > > I hope this makes sense! Do you have any ideas as to what I

might

> > be

> > > > > doing

> > > > > > wrong?

> > > > > >

> > > > > > Thanks!

> > > > > > Chad

> > > > > >

> > > > > >

> > > > >

> > > > >

> > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

The article I pointed you too:

Q1371002. Changing the colors of the markers depending on a condition

Deals with changing colors to points INDIVIDUALLY, as a matter of fact the

sample only has ONE series.

Please review the sample and the documentation on the related properties for

more information (Color, OpenDataEx, etc.).

If you need help about applying this to your specific case you can contact

our support department either by phone or e-mail.

--

FP

Software FX Support

"Chad Lansford" <chartfx@shillglen.com> wrote in message

news:T#keAT6pCHA.2684@webserver1.softwarefx.com...

> Anyone? Anyone???

>

> Thanks,

> Chad

>

>

> "Chad Lansford" <chartfx@shillglen.com> wrote in message

> news:wVH8YhipCHA.2684@webserver1.softwarefx.com...

> > Correction: The data IS displaying correctly, but the colors are not...

> >

> > Sorry,

> > Chad

> >

> > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > news:$26hffipCHA.2684@webserver1.softwarefx.com...

> > > Thanks! The data is not displaying correctly. HOWEVER, I can't get

> the

> > > colors to display correctly, I read the article that you told me

about,

> > but

> > > it only gives instructions on how to set the color for a "Series".

> Since

> > > the "Series" on my gantt chart does not represent the X-Axis data, any

> > color

> > > settings I make are still showing incorrectly. Is there any way to

set

> > the

> > > color for each and every single point on the chart individually?? If

> > there

> > > is, I can't seem to find it in the documentation.

> > >

> > > Thanks,

> > > Chad

> > >

> > >

> > > "Software FX Support" <support@softwarefx.com> wrote in message

> > > news:eSlKyjhpCHA.2684@webserver1.softwarefx.com...

> > > > I think the problem comes from the misunderstanding on how data is

> > stored

> > > in

> > > > Chart FX.

> > > >

> > > > The data in Chart FX is a table of rows and columns, all rows and

> column

> > > are

> > > > the SAME SIZE.

> > > >

> > > > The data that is showing up without being set is just being

> initialized

> > to

> > > > its default value (zero). To give you a better understanding on how

> the

> > > data

> > > > is stored in the chart, you may turn on the Data Editor (DataEditor

=

> > > true).

> > > >

> > > > The second problem is that you are thinking that the labels on the

> left

> > > side

> > > > are the series. They are not. What you see in the left side are the

> > X-Axis

> > > > labels. Do not refer to them as series, series are the blue and the

> red

> > > and

> > > > they can be together in the same group.

> > > >

> > > > To create a chart like the one you want is not trivial, as you want

> > > multiple

> > > > instances of the same color within the same group, namely the 2 blue

> > bars

> > > at

> > > > the bottom of your chart.

> > > >

> > > > Lets forget about the color for a second (I'll come back to that

> later).

> > > To

> > > > obtain this chart your data has to be passed as follows:

> > > >

> > > > IniValueEx(0,0) = 8A

> > > > ValueEx(0,0) = 9A

> > > > IniValueEx(1,0) = 9A

> > > > ValueEx(1,0) = 10A

> > > > IniValueEx(0,1) = 11A

> > > > ValueEx(0,1) = 12P

> > > > IniValueEx(1,1) = 0

> > > > ValueEx(1,1) = CHART_HIDDEN

> > > >

> > > > If this is not clear enough. This is how the data needs to go into

the

> > > chart

> > > > to get what you want. If you are passing an XML to Chart FX I'll be

> > happy

> > > to

> > > > show you how it should be rearranged.

> > > >

> > > > After this you will obtain a chart similar to the one you want but

the

> > > > colors will be different. Check out the following KB article that

> shows

> > > you

> > > > how to assign colors individually.

> > > >

> > > > Q1371002. Changing the colors of the markers depending on a

condition

> > > >

> > > > --

> > > > FP

> > > > Software FX Support

> > > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > > news:NAXmBxfpCHA.2284@webserver1.softwarefx.com...

> > > > > Thanks for your response!! Unfortunately, I'm still having

> problems.

> > > > > Here's some screen shots with descriptions in them.

> > > > >

> > > > > The first one (gantt_current.gif) shows how the chart is

displaying

> > > right

> > > > > now, and the descriptions in the image tell what is wrong with it.

> > The

> > > > > second one (gantt_fixed.gif) shows how I want it to display.

Here's

> > the

> > > > > exact data (in XML format) that I'm using:

> > > > >

> > > >

> > >

> >

>

> --------------------------------------------------------------------------

> > > > --

> > > > > ------

> > > > > <apiResult errorCode="0" errorDesc="Ok" diagnose="0">

> > > > > <getRackLiftingsResult

> > > > > shiftStart="2002-11-18T06:00:00"

> > > > > shiftEnd="2002-11-18T18:00:00"

> > > > > numOfSuppliers="2"

> > > > > >

> > > > > <supplier

> > > > > numOfRackLiftings="2"

> > > > > >

> > > > > <rackLifting

> > > > > loadStartTime="2002-11-18T08:00:00"

> > > > > loadEndTime="2002-11-18T09:00:00"

> > > > > />

> > > > > <rackLifting

> > > > > loadStartTime="2002-11-18T09:00:00"

> > > > > loadEndTime="2002-11-18T10:00:00"

> > > > > />

> > > > > </supplier>

> > > > > <supplier

> > > > > numOfRackLiftings="1"

> > > > > >

> > > > > <rackLifting

> > > > > loadStartTime="2002-11-18T11:00:00"

> > > > > loadEndTime="2002-11-18T12:00:00"

> > > > > />

> > > > > </supplier>

> > > > > </getRackLiftingsResult>

> > > > > </apiResult>

> > > >

> > >

> >

>

> --------------------------------------------------------------------------

> > > > --

> > > > > ------

> > > > >

> > > > > Thanks for all the help!!

> > > > > Chad

> > > > >

> > > > >

> > > > >

> > > > > "Software FX Support" <support@softwarefx.com> wrote in message

> > > > > news:6c#KkDcpCHA.2632@webserver1.softwarefx.com...

> > > > > > The problem is that you are using the Axis legend as your series

> > > Legend

> > > > > when

> > > > > > you do:

> > > > > >

> > > > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > > > >

> > > > > > Instead, you should do:

> > > > > >

> > > > > > Chart1.Serleg(x) = "Series #" + (x+1);

> > > > > >

> > > > > > The suppliers are your series, your X-Axis labels should be the

> > number

> > > > of

> > > > > > Rack Lifting.

> > > > > >

> > > > > > If this is not what you want, then your data is being set

> > incorrectly,

> > > > > when

> > > > > > you use:

> > > > > >

> > > > > > Chart.ValueEx(x,z)

> > > > > >

> > > > > > x is the Series index

> > > > > > z is the Point Index

> > > > > >

> > > > > > A Gantt chart is drawn as <number of points> groups of <number

of

> > > > series>

> > > > > > bars. A label is displayed for each group.

> > > > > >

> > > > > > I hope this all make sense to you, if you still have questions,

> > please

> > > > > post

> > > > > > again, a screenshot of you are getting indicating what's wrong

and

> > how

> > > > it

> > > > > > should be would be most helpful.

> > > > > >

> > > > > > --

> > > > > > FP

> > > > > > Software FX Support

> > > > > > "Chad Lansford" <chartfx@shillglen.com> wrote in message

> > > > > > news:XUW6YaUpCHA.2632@webserver1.softwarefx.com...

> > > > > > > Hi,

> > > > > > >

> > > > > > > I'm making a Gantt chart, but seem to be having trouble

getting

> > the

> > > > > > > information to display correctly. It's charted correctly,

> meaning

> > > > that

> > > > > > the

> > > > > > > start and end times that I set are represented correctly.

> > However,

> > > > when

> > > > > I

> > > > > > > mouseover each record, the series seems to be incorrect, and

> it's

> > > > > > > color-coded wrong. I'll try to explain:

> > > > > > >

> > > > > > > Here's my data (it's in XML format, so it doesn't actually

look

> > like

> > > > > > this):

> > > > > > > ---------------

> > > > > > > Series #1 (Represented as "Suppliers" in the code below):

> > > > > > > Record #1 (Represented as "Rack Liftings" in the code

> below):

> > > > > > > loadStartTime = "11/18/2002 8:00:00"

> > > > > > > loadEndTime = "11/18/2002 9:00:00"

> > > > > > >

> > > > > > > Record #2:

> > > > > > > loadStartTime = "11/18/2002 12:00:00"

> > > > > > > loadEndTime = "11/18/2002 13:00:00"

> > > > > > >

> > > > > > > Series #2:

> > > > > > > Record #1:

> > > > > > > loadStartTime = "11/18/2002 11:00:00"

> > > > > > > loadEndTime = "11/18/2002 12:00:00"

> > > > > > > ---------------

> > > > > > >

> > > > > > > Here's my code (using JScript by the way...):

> > > > > > > ---------------

> > > > > > > //loop through suppliers to build chart data

> > > > > > > var intRackLiftingCounter = 0, intSupplierCounter = 1,

> > > > > numOfRackLiftings,

> > > > > > > rackLiftingAtts;

> > > > > > > for (x=0; x<numOfSuppliers; x++) {

> > > > > > > //get number of rack liftings in current supplier

> > > > > > > supplierAtts = supplierInfo.item(x).attributes;

> > > > > > > numOfRackLiftings =

> > > > > > > Number(supplierAtts.getNamedItem("numOfRackLiftings").value);

> > > > > > > Chart.Axis(2).Label(x) = "Series #" + (x+1);

> > > > > > >

> > > > > > > //now loop through those rack lifting records

> > > > > > > for (z=0; z<numOfRackLiftings; z++) {

> > > > > > > rackLiftingAtts =

> > > > > > > rackLiftingInfo.item(intRackLiftingCounter).attributes;

> > > > > > > //set chart data

> > > > > > > Chart.IniValueEx(x,z) =

> > > > > > >

formatDate(rackLiftingAtts.getNamedItem("loadStartTime").value,

> > > > > > > "JavaScript").getVarDate();

> > > > > > > Chart.ValueEx(x,z) =

> > > > > > > formatDate(rackLiftingAtts.getNamedItem("loadEndTime").value,

> > > > > > > "JavaScript").getVarDate();

> > > > > > > intRackLiftingCounter++;

> > > > > > > }

> > > > > > > intSupplierCounter++;

> > > > > > > }

> > > > > > > ---------------

> > > > > > >

> > > > > > > Each records' "loadStartTime" and "loadEndTime" is plotted

> > > correctly,

> > > > > > > however, the chart seems to group them into the incorrect

> series.

> > > So,

> > > > > if

> > > > > > I

> > > > > > > mouseover the "Series #1/Record #1" record, it says: "Series

#1

> > From

> > > > 8AM

> > > > > > to

> > > > > > > 9AM" (which is correct). If I mouseover the "Series #2/Record

> #1"

> > > > > record,

> > > > > > > it says "Series #1 From 11AM to 12PM" (the time is correct,

but

> > the

> > > > > series

> > > > > > > number is not). Then "Series #1/Record #2" says "Series #2

From

> > > 12PM

> > > > to

> > > > > > > 13PM" (the time is correct, but the series number is not).

> > > > > > >

> > > > > > > I hope this makes sense! Do you have any ideas as to what I

> might

> > > be

> > > > > > doing

> > > > > > > wrong?

> > > > > > >

> > > > > > > Thanks!

> > > > > > > Chad

> > > > > > >

> > > > > > >

> > > > > >

> > > > > >

> > > > >

> > > > >

> > > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...