473,289 Members | 2,141 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

need help plotting chart in VB

hi guys, i need help plotting chart in Vb, im using SQL to plot the chart but when i use it the first data wont be included in my chart , let say if it was supposed to be data range from 3/1/2006 to 3/31/2006 , data from 3/1/2006 wont be displayed but started at 3/2/2006! the code im using is :

rs.Open "Select S1,S2,S3,S4,Q from test2 where [Nama Pa] ='" & x & "' and Tarikh between #" & mula & "# and #" & tamat & "# ORDER BY Tarikh ASC", cn, adOpenDynamic, adLockOptimistic

and one more thing, can or cannot MSchart display date such as 3/1/2006 as X-axis? because in my case it would'nt show anything or i only has to use something like text or number but not date??

Im using Vb 6 and Ms Access, plot the chart using MsChart.

please help me, any help would be greatly appreciated. :)
Jul 17 '06 #1
0 2726

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Gerrit Holl | last post by:
Hi, I have a dictionairy containing DateTime objects as keys and integers as values. What would be the easiest way to create a simple plot of these, with a number axis versus a time axis? What...
12
by: Russ | last post by:
I'm interested in setting up a web page where live data can be displayed in real-time on the web page. For example: I would like to display a (nice looking) graph of some data value versus time...
30
by: nephish | last post by:
Hey there, i have tried about every graphing package for python i can get to work on my system. gnuplot, pychart, biggles, gdchart, etc.. (cant get matplot to work) so far, they all are working...
3
by: bchaillou | last post by:
Hello I've got a question about plotting data on either access or excel. This is what is buggin me. I've got a series of data fields that needs to be plotted Their values are coming from...
1
by: Mudcat | last post by:
Hi, I have looked through the previous suggestions on graphing modules and have been able to find some good suggestions. However I was wondering about something more specific. I am going to...
6
by: ptek | last post by:
Hello all, I'm looking for a free libray for plotting 2D charts that can be integrable on C# or C++ projects under visual studio (.NET ou VS6.0). I searched using google and yahoo but I didn't...
2
by: fegd07 | last post by:
Hi, I am trying to make an spacial plot ( scatter XY plot) with more than one serie using the pivot chart option but apparentl this is not possible. A graph with multiple series is possible to do...
2
by: Amit | last post by:
Hello Gurus, I am entering data through data grid , what i want is that once user enter the data in the grid and click on button graph should come on the basis of data values are like X ...
4
by: Jon Harrop | last post by:
Does WPF provide graph and chart plotting functionality? If so, are there any C# examples out there? -- Dr Jon D Harrop, Flying Frog Consultancy Ltd. http://www.ffconsultancy.com/products/?u
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.