Setting Values/Xvalues to an Array Variable

  • 17 years ago

    I have this array variable that contains a set of values which i would like to use as a series for an xy scatter plot but I can't seem to get the syntax right.  Any suggestions?

    Set Coupons = ActiveChart.SeriesCollection.NewSeries
    Coupons.Name = "Coupon Rate"
    Coupons.Values = CouponArray
    Coupons.XValues = Dates

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“C++: an octopus made by nailing extra legs onto a dog.” - Steve Taylor