Re: Help with Gantt chart

[User (Legacy)]

Hi,

I tried diplaying the graph for the following example. The Projected value got from the database, appears on the X-Axis on the left side. Is there a way to have just Activity numbers on the X-Axis (ie) 1, 2, 3... and have the Projected value as labels on the corresponding floating bars ?

Thanks a bunch,

Sri

"SoftwareFX Support" <support@softwarefx.com> wrote in message news:<UkeoCtX6CHA.2116@webserver1.softwarefx.com>...

> The using DataType sample can be easily modified for Gantt chats as follows:

> 

> <!-- Include this file so we can use all the ChartFX constants -->

> <!-- #include virtual="/Include/CfxIE.inc" -->

> 

> <%

> Set chart = Server.CreateObject("ChartFX.WebServer")

> 

> chart.Gallery = Gantt

> 

> ' Create the database connection object

> Set Conn = Server.CreateObject("ADODB.Connection")

> 

> ' Open the ODBC data source

> Conn.Open Application("CfxIEConn")

> 

> ' Execute the SQL statement that will return the data

> Set RS = Conn.Execute("SELECT Month,Sales,Projected From

> CIEDemoSales")

> 

> 'I can now ignore the second set of values (projected) from the

> recordset.

> chart.datatype(0) = cdt_legend

> chart.datatype(1) = cdt_value

> chart.datatype(2) = cdt_inivalue ' Projected will be the Initial value

> for the bar. The bar will go from Projected to Sales

> 

> ' Assign the contents of the ResultSet to the Chart

> chart.AdoResultset RS

> 

> ' Close the connection

> Conn.Close

> %>

> <%= chart.GetHtmlTag("500","350") %>

> 

> --

> FP

> Software FX, Inc.

> 

>