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 ?








      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.