7 Replies Latest reply: Sep 8, 2009 9:58 AM by denis matteazzi RSS

    creating bar graph via macro

      Hello everybody,

      I'd like build a bar graph programatically via macro script.

      I found sometihig like this in API tutorial


      set Graph = ActiveDocument.Sheets("Assistenza").CreatePieChart

      Graph.AddDimension "C_ARTICOLO_8"

      Graph.AddExpression "sum([Quantità transazione])"

      Graph.AddExpression "sum(%)"

      end sub

      My problem is thsat the Expression in not a function of any DIMENSION but values coming from another linear table.

      Is there any function or method allow me to build a dimension with values from another table(graph).?

      Something creating dimension on the fly?


      Thank you for reading y post.

      Denis Matteazzi