User (Legacy) Posted December 16, 2002 Report Share Posted December 16, 2002 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 More sharing options...
Software FX Posted December 17, 2002 Report Share Posted December 17, 2002 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 More sharing options...
User (Legacy) Posted December 17, 2002 Author Report Share Posted December 17, 2002 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 More sharing options...
Software FX Posted December 17, 2002 Report Share Posted December 17, 2002 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 More sharing options...
User (Legacy) Posted December 17, 2002 Author Report Share Posted December 17, 2002 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 More sharing options...
User (Legacy) Posted December 17, 2002 Author Report Share Posted December 17, 2002 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 More sharing options...
User (Legacy) Posted December 19, 2002 Author Report Share Posted December 19, 2002 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 More sharing options...
Software FX Posted December 20, 2002 Report Share Posted December 20, 2002 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.