and excel Portugal
  • 13 years ago

    i'm using vs2003 to develop an solution and i'm using excel to export some data to charts, but i'm having some problems with changing the the values of the series

    count of the series


    ser As Excel.Series 

    Dim sc As Excel.SeriesCollection = CType(oChart.Chart.SeriesCollection, Excel.SeriesCollection)

    ser = sc.Item(sc.Count)

    then for selecting the chart

    oChart = oExcell.Worksheets("sheetname").ChartObjects("chartnumber")

    and for defining the series

    sc.Item(1).XValues = "=sheetname!R3C7:R" & maxdpos & "C7"

    sc.Item(1).Values = "=sheetname!R3C8:R" & maxdpos & "C8"

    sc.Item(2).Values = "=sheetname!R3C28:R" & maxdpos & "C28"


    btw maxdpos is a variable that recieves a value in a previous sub.

    i know that it's possible to do it, because the app i'm working was created in asp, and it works


    can anyone give me some pointers, or lead me in the right direction

    any help would be appreciatted


    thanks in advance

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.

“Nine people can't make a baby in a month.” - Fred Brooks