How to show list of information when I move my mouse to the chart in VB.NET ?

Question

0.00/5 (No votes)

See more:

Hello everyone, I have some charts in my vb.net forms which I would like to make them more sophisticated . I have been googling but I haven't found anything so specific.
I just want to know if it's possible and what method should I use or which direction should I go to..

I have connected my chart with SQL database values.

Here is some of the code that I use it:

Private Sub LoaddayData()

       Chartday.DataSource = GetData1()
       Chartday.Series("Day").Points.Clear()
       Chartday.Series("Day").XValueMember = "Day"
       Chartday.Series("Day").YValueMembers = "Total"
       Chartday.Series("Day").ChartType = SeriesChartType.Spline
       Chartday.Series("Day").IsValueShownAsLabel = True
End Sub

Private Function GetData1() As DataTable

       Dim dtChartData As New DataTable()

       Using conn As New SqlConnection(ConfigurationManager.ConnectionStrings("db").ConnectionString)
           Using cmd As New SqlCommand("Chart_daily1", conn) ' Total working hours in the month -- step3
               cmd.CommandType = CommandType.StoredProcedure

               conn.Open()
               'Counts Year only'
               cmd.Parameters.AddWithValue("@DateD", DateTimePickerM.Text)
               cmd.Parameters.AddWithValue("@Department", ComboBoxDepartment.Text)

               Dim reader As SqlDataReader = cmd.ExecuteReader()
               dtChartData.Load(reader)

           End Using
       End Using

       Return dtChartData

   End Function

Thank you,
Your help is appreciated.

What I have tried:

Here are some examples that I have been trying but here it shows only the information that already is in the datachart How to display information of a line chart by doing mouse over[^]

So I was wondering if it is possible to show more information by selecting or just moving the mouse over the curve. Like a list of information or some of that kind.

Thank you,
Best Rergards

Posted 22-Jul-20 6:12am

Member 13410460

Updated 24-Jul-20 4:33am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gerry Schmitz · Accepted Answer · 2020-07-22T07:22:00

Solution 1

The "info" is displayed via the .Text property of the CalloutAnnotation object (in the example); add any extra info you want.

With ta
    .AnchorDataPoint = Chart1.Series(0).Points(result.PointIndex)
    .X = thisPt.X + 1
    .Y = thisPt.Y + 1
    .Text = thisPt.ToString
    .CalloutStyle = CalloutStyle.SimpleLine
    .ForeColor = Color.Red
    .Font = New Font("Tahoma", 12, FontStyle.Bold)
End With

Posted 22-Jul-20 7:22am

Gerry Schmitz

Updated 22-Jul-20 7:23am

v2

Comments

Member 13410460 22-Jul-20 13:30pm

Thank you for your reply and help, I will test it now.
Bests

Member 13410460 22-Jul-20 16:39pm

I looked into that but still don't know how to do it, it looks fairly complicated for my level of coding.

[no name] 23-Jul-20 0:36am

It's as hard as you want to make it. You can dedicate a multi-line textbox (or any other "list type control") on the form for "logging" instead of "annotating". It's called designing; the limits are your imagination.

Member 13410460 24-Jul-20 10:08am

Is there a chance that I can Connect my SQL Query inside of it ?
For example here in this form :

Dim thisPt As New PointF(CSng(Chartday.Series("Day").Points(Result.PointIndex).XValue),
CSng(Chartday.Series("Day").Points(Result.PointIndex).YValues(0)))

And if yes , how can I do that ?

[no name] 24-Jul-20 12:42pm

You format the results of your query as a "string" (for example) and add it to the ".Text" (or whatever) property of whatever control is used to track the mouse. Draw a picture of your ui and visualize how the components should interact. Nobody gets it right if all they do is "think" about it.