Tks for your response.
Now, I'm trying to make the following chart, I made first with Excel 2000. I have a table with the data and make a simple chart stacked column.
Muy.Dificil Dificil Media Facil Muy.Facil
02/11 33 3 3 1
9/11 28 4 3 1
16/11 27 2 2 1 1
23/11 19
30/11 26 1 1
1/12 30 1 1
Selecting this data and making a simple chart give the char that I want, but if I load this information in Tee make other chart. Maybe Tee is taking the series in other way.
This is the code
Code: Select all
Private Sub Command1_Click()
Dim iSer As Integer
iSer = TChart1.AddSeries(scBar)
TChart1.Series(iSer).Add 33, "02/11", clTeeColor
TChart1.Series(iSer).Add 28, "09/11", clTeeColor
TChart1.Series(iSer).Add 27, "16/11", clTeeColor
TChart1.Series(iSer).Add 19, "23/11", clTeeColor
TChart1.Series(iSer).Add 26, "30/11", clTeeColor
TChart1.Series(iSer).Add 30, "1/12", clTeeColor
TChart1.Series(iSer).Marks.Visible = False
TChart1.Series(iSer).ColorEachPoint = False
TChart1.Series(iSer).Color = vbRed
TChart1.Series(iSer).asBar.MultiBar = mbSelfStack
TChart1.Series(iSer).Title = "Muy Dificil"
iSer = TChart1.AddSeries(scBar)
TChart1.Series(iSer).Add 3, "02/11", clTeeColor
TChart1.Series(iSer).Add 4, "09/11", clTeeColor
TChart1.Series(iSer).Add 2, "16/11", clTeeColor
TChart1.Series(iSer).Add 0, "23/11", clTeeColor
TChart1.Series(iSer).Add 0, "30/11", clTeeColor
TChart1.Series(iSer).Add 0, "1/12", clTeeColor
TChart1.Series(iSer).Marks.Visible = False
TChart1.Series(iSer).ColorEachPoint = False
TChart1.Series(iSer).Color = vbYellow
TChart1.Series(iSer).asBar.MultiBar = mbSelfStack
TChart1.Series(iSer).Title = "Dificil"
iSer = TChart1.AddSeries(scBar)
TChart1.Series(iSer).Add 3, "02/11", clTeeColor
TChart1.Series(iSer).Add 3, "09/11", clTeeColor
TChart1.Series(iSer).Add 2, "16/11", clTeeColor
TChart1.Series(iSer).Add 0, "23/11", clTeeColor
TChart1.Series(iSer).Add 0, "30/11", clTeeColor
TChart1.Series(iSer).Add 0, "1/12", clTeeColor
TChart1.Series(iSer).Marks.Visible = False
TChart1.Series(iSer).ColorEachPoint = False
TChart1.Series(iSer).Color = vbGreen
TChart1.Series(iSer).asBar.MultiBar = mbSelfStack
TChart1.Series(iSer).Title = "Media"
iSer = TChart1.AddSeries(scBar)
TChart1.Series(iSer).Add 1, "02/11", clTeeColor
TChart1.Series(iSer).Add 1, "09/11", clTeeColor
TChart1.Series(iSer).Add 1, "16/11", clTeeColor
TChart1.Series(iSer).Add 0, "23/11", clTeeColor
TChart1.Series(iSer).Add 1, "30/11", clTeeColor
TChart1.Series(iSer).Add 1, "1/12", clTeeColor
TChart1.Series(iSer).Marks.Visible = False
TChart1.Series(iSer).ColorEachPoint = False
TChart1.Series(iSer).Color = vbWhite
TChart1.Series(iSer).asBar.MultiBar = mbSelfStack
TChart1.Series(iSer).Title = "Facil"
iSer = TChart1.AddSeries(scBar)
TChart1.Series(iSer).Add 0, "02/11", clTeeColor
TChart1.Series(iSer).Add 0, "09/11", clTeeColor
TChart1.Series(iSer).Add 1, "16/11", clTeeColor
TChart1.Series(iSer).Add 0, "23/11", clTeeColor
TChart1.Series(iSer).Add 1, "30/11", clTeeColor
TChart1.Series(iSer).Add 1, "1/12", clTeeColor
TChart1.Series(iSer).Marks.Visible = False
TChart1.Series(iSer).ColorEachPoint = False
TChart1.Series(iSer).Color = vbBlue
TChart1.Series(iSer).asBar.MultiBar = mbSelfStack
TChart1.Series(iSer).Title = "Muy Facil"
End Sub
Please, I need to make this kind of chart for my app.
Tks again
Christian Sabino