12 Replies Latest reply: Jul 8, 2016 12:55 PM by Sunny Talwar RSS

    Chart Average line value -> use it in other chart

    Tobias Rueger

      UPDATE: I added sample:

       

      load script loads excel file with date / value 1

       

      this is shown in first chart: together with internal average line.

       

       

      and i need to know this average value to use it in a second chart:

      e.g. this second chart uses other values but those values need to be coloured if they are higher or lower than the average value of the first diagram ?

       

      My question is: can we get this value within module scripts ?

       

       

       

       

       

      hi,

       

      how can I use a chart average (trend line) value in another diagramme ?

       

      is there any possibility to read this average value (trend line) within a macro ? like Chart.properties and then the average value ?

       

      I could not find any solution.

      Thanks for your help.