Consult the chart of X coordinate calls to the database data label?-CodePudding

My database using ACCESS, as shown in the figure below:

Line chart has to normal, according to the diagram below:

I wrote the program is as follows:

 Adodc3. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0. Data Source="& amp; App. The Path & amp; "\ db. MDB; Persist Security Info=False "
Adodc3. RecordSource="select * from table" 
Adodc3. Refresh 

If Adodc3. You. RecordCount & lt; 20 Then=
ReDim DynArra2 (9 To 11, 1 To Adodc3. You. RecordCount) 
End the If 
If Adodc3. You. RecordCount & gt; 20 Then 
ReDim DynArra2 (9 To 11, Int (Adodc3. You. RecordCount - 20) To Adodc3. You. RecordCount) 
End the If 

For I=Int (Adodc3. You. RecordCount - 20) To Adodc3. You. RecordCount 
Adodc3. You. AbsolutePosition=I 
For k=9 To 11 
DynArra2 (k, I)=Adodc3. You. The Fields (k) 
Next k 
Next I 
MSChart2. Plot. SeriesCollection (1). LegendText="maximum" 
MSChart2. Plot. SeriesCollection (2). LegendText="minimum" 
MSChart2. Plot. SeriesCollection (3). LegendText="average" 

MSChart2. ChartData=https://bbs.csdn.net/topics/DynArra2 ()

Now want to consult, X each column of the labels on the chart (C1, C2 and C3...... ) how to obtain the database time that a list of data? That is to say, the X axis each column of the tags are three values (maximum, minimum, average) generated time,
Please pass by friends, masters, webmaster glad, thank you!

CodePudding user response:

Please pass by friends, masters, webmaster glad, thank you!

CodePudding user response:

My needs in a way of expression, I wonder if this can express more clearly,

CodePudding user response:

No one is willing to grant instruction?

CodePudding user response:

Look not to understand, how do the maximum in the bottom, as minimum, average how on top, as if is a maximum, the broken line, should be easy to achieve, you give me your data, do for you,