Software FX Community

# Data displaying incorrectly on my Gantt chart

## 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):
Record #2:
Series #2:
Record #1:
---------------
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) =
"JavaScript").getVarDate();
Chart.ValueEx(x,z) =
"JavaScript").getVarDate();
intRackLiftingCounter++;
}
intSupplierCounter++;
}
---------------
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!
##### 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);
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):
>
>     Record #2:
>
> Series #2:
>     Record #1:
> ---------------
>
> 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) =
> "JavaScript").getVarDate();
>         Chart.ValueEx(x,z) =
> "JavaScript").getVarDate();
>         intRackLiftingCounter++;
>     }
>     intSupplierCounter++;
> }
> ---------------
>
> 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!
>
>```
##### 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
/>
<rackLifting
/>
</supplier>
<supplier
numOfRackLiftings="1"
>
<rackLifting
/>
</supplier>
</getRackLiftingsResult>
</apiResult>
----------------------------------------------------------------------------
------
Thanks for all the help!!
"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);
>
>
> 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) =
> > "JavaScript").getVarDate();
> >         Chart.ValueEx(x,z) =
> > "JavaScript").getVarDate();
> >         intRackLiftingCounter++;
> >     }
> >     intSupplierCounter++;
> > }
> > ---------------
> >
> > 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!
> >
> >
>
>```
##### 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
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
> />
> <rackLifting
> />
> </supplier>
> <supplier
>   numOfRackLiftings="1"
> >
> <rackLifting
> />
> </supplier>
> </getRackLiftingsResult>
> </apiResult>
> --------------------------------------------------------------------------
--
> ------
>
> Thanks for all the help!!
>
>
>
> "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) =
> > > "JavaScript").getVarDate();
> > >         Chart.ValueEx(x,z) =
> > > "JavaScript").getVarDate();
> > >         intRackLiftingCounter++;
> > >     }
> > >     intSupplierCounter++;
> > > }
> > > ---------------
> > >
> > > 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!
> > >
> > >
> >
> >
>
>
>```

##### 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,
"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
> > />
> > <rackLifting
> > />
> > </supplier>
> > <supplier
> >   numOfRackLiftings="1"
> > >
> > <rackLifting
> > />
> > </supplier>
> > </getRackLiftingsResult>
> > </apiResult>
>
> --------------------------------------------------------------------------
> --
> > ------
> >
> > Thanks for all the help!!
> >
> >
> >
> > "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) =
> > > > "JavaScript").getVarDate();
> > > >         Chart.ValueEx(x,z) =
> > > > "JavaScript").getVarDate();
> > > >         intRackLiftingCounter++;
> > > >     }
> > > >     intSupplierCounter++;
> > > > }
> > > > ---------------
> > > >
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!
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>```
##### Share on other sites

```Correction:  The data IS displaying correctly, but the colors are not...
Sorry,
"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,
>
>
> "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
> > > />
> > > <rackLifting
> > > />
> > > </supplier>
> > > <supplier
> > >   numOfRackLiftings="1"
> > > >
> > > <rackLifting
> > > />
> > > </supplier>
> > > </getRackLiftingsResult>
> > > </apiResult>
> >
>
> --------------------------------------------------------------------------
> > --
> > > ------
> > >
> > > Thanks for all the help!!
> > >
> > >
> > >
> > > "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,
> > > 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>```
##### Share on other sites

```Anyone?  Anyone???
Thanks,
"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 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,
> >
> >
> > "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
> > > > />
> > > > <rackLifting
> > > > />
> > > > </supplier>
> > > > <supplier
> > > >   numOfRackLiftings="1"
> > > > >
> > > > <rackLifting
> > > > />
> > > > </supplier>
> > > > </getRackLiftingsResult>
> > > > </apiResult>
> > >
> >
>
> --------------------------------------------------------------------------
> > > --
> > > > ------
> > > >
> > > > Thanks for all the help!!
> > > >
> > > >
> > > >
> > > > "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,
> > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>```
##### 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
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 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 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
> > 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,
> > >
> > >
> > > "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,
> > > > > 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) =
> > > > > > >
> > > > > > > "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
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>```

#### Archived

This topic is now archived and is closed to further replies.

×