method ExChart.Add (Data as Variant)
Adds data manually.

TypeDescription
Data as Variant A double, long expression that indicates the value being added, an array of double or long values that indicates the list of values being added. 
Use the Add method to add manually the data to the chart. Use the Draw method to reflect the changes in the chart. Use the Clear method to clear the data in the chart.

The following sample shows how to add manually data to the chart:

With ExChart1
    .Add 10
    .Add 2
    .Add 3.5
    .Add 1.5
    .Add 4
    .Add 4.4
    .Add Array(1, 2, 3, 2, 3, 3, 3.4, 4, 5)
    .Draw
End With