Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

xy scatter graph in vb 6.0

Posted on 2009-04-01
7
Medium Priority
?
828 Views
Last Modified: 2012-05-06
I want to use whatever capability vb 6.0 has to make graph in it using data from an array.
in short:
Data type : xyscatter
X data : xVAlues(20)
Y data: yValues(20)
Min of x axis: -20
MaximumMin of x axis: -20
min of y axis : 20
 max of x axis : 20
Can I use the mschart1 capability to do this task.
Thank you for the anticipated help of all the experts.
0
Comment
Question by:Aiysha
  • 3
  • 3
7 Comments
 
LVL 19

Accepted Solution

by:
Rimvis earned 2000 total points
ID: 24047105
Check this:

Creating 2D XY scatter charts on an unbound MSChart Control
http://vbcity.com/pubs/article.asp?alias=scatter_charts
0
 

Author Comment

by:Aiysha
ID: 24072883

My code is based on the link you have send, I have adapted it according to my needs, all is need to be able to put text in the label for the points.
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 24074910
Like this?

    With .Plot.SeriesCollection(CurSeries * 2 - 1).DataPoints(-1).DataPointLabel
        .LocationType = VtChLabelLocationTypeAbovePoint
        .VtFont.Size = 8
    End With

Open in new window

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Aiysha
ID: 24112384
I am trying to put a text label on the data points in the mschart1 ..so far I have the following code which does not work

For lRow = 1 To UBound(ChartPoints, 1)
 .plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.LocationType = VtChLabelLocationTypeLeft
 .plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.Custom = True
 .plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.Component = VtChLabelComponentSeriesName
 .plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.Text = T(lRow)
   
Next lRow
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 24114018
Sorry, not sure how to do it...
0
 

Author Comment

by:Aiysha
ID: 25899373
None of the above solution worked for me. I ended up opening an excel workbook in vb 6.0 and looking at my graph as if working directly in Excel.

0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question