How can I draw this chart in VBScript

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

How can I draw this chart in VBScript

Logged in as: Guest

arrSession:exec spGetSession 2,3,26239

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> How can I draw this chart in VBScript
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

How can I draw this chart in VBScript - 9/23/2005 2:14:15 AM

cs168

Posts: 3
Score: 0
Joined: 9/23/2005
Status: offline

Original message moved by Snipah
Reason : chart with asp relation
Hi,
I believe that in VB/Java script Line chart can be draw by getting the data from access database, can some expert show me & guide me on making this happen please.Tks.
My data is like this:-

and my graph will look like this :-

Appreciated if some expert willing to help, all advise & help are welcome....Tq

Post #: 1

RE: How can I draw this chart in VBScript - 9/23/2005 2:19:07 AM

Snipah

Posts: 1341
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline

are you using ASP (or ASP.NET)?

Snipah

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to cs168)

Post #: 2

RE: How can I draw this chart in VBScript - 9/23/2005 2:21:33 AM

cs168

Posts: 3
Score: 0
Joined: 9/23/2005
Status: offline

quote:

ORIGINAL: Snipah

are you using ASP (or ASP.NET)?

Snipah

Hi Snipah,
Tks for the response, Yes I do have asp page to let user update the data to access database..
I am now stuck on how to display the line chart to user on my page, Can u please advise & guide me on maing this happen..tq

(in reply to Snipah)

Post #: 3

RE: How can I draw this chart in VBScript - 9/23/2005 5:27:41 AM

Snipah

Posts: 1341
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline

I will move this post to the proper ASP section, where you also will find this (http://www.visualbasicscript.com/m_25277/tm.htm) topic on creating a chart....

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to cs168)

Post #: 4

RE: How can I draw this chart in VBScript - 9/25/2005 6:23:23 AM

icode4u

Posts: 7
Score: 0
Joined: 9/24/2005
Status: offline

Put your recordset into an array then you can get the upper and lowerbounds of the array then the lines or points can be calculated. The rest is graphics or css.
Make connection
Set Conn = Server.CreateObject("ADODB.Connection")
Conn=Application("yourConnectionString")
Set displayrs = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT Count(fieldname) AS CountOfData, Daily FROM tbldata"
displayrs.open SQL, conn, 1, 3, 1
displayrs.movelast
lngRC = displayrs.recordcount
displayrs.movefirst
Redim myarray(lngRC)
Redim myarray2(lngRC)
Do While Not displayrs.EOF
myarray(i) = displayrs.Fields("CountOfData").Value' these are the values
myarray2(i) = somevariable' this is the legend
i=i+1
displayrs.movenext
Loop
Now that you have the data in the arrays you just put it into tables. Background colored colspsan or graphics are upper and lower bounds.

< Message edited by icode4u -- 9/25/2005 6:26:30 AM >

(in reply to Snipah)