2 Replies Latest reply: Jul 11, 2012 2:45 AM by perry van der meijden

# calculation sum of values in graph

Hi,

I have a table like:

date      value1  value2

1-1-12    12          1

4-1-12    11          16

7-1-12    17          12

14-1-12    12          8

etc

With this table I want to create a graph with on the X-as the date and on the Y-axis value 1 and the sum of value 2 as a straight line. So if I make a graph from 1-1-12 to 14-1-12, I want to show value 37 (=1+16+12+8) as a horizontal line from 1-1-12 until 14-1-12.

I've tried variables without success. Then I've calculated the sum of value2 in a textbox. The textbox contains the right value (37), but I can't get the value from the textbox into the graph.

any other ideas???

greetz

Per

• ###### Re: calculation sum of values in graph

Try to show sum of value2 as horizontal reference line. Reference line can be defined in the Presentation tab of the chart properties window. You can give the expression Sum({1} value2) as the value of the reference line. You may have to set the static max for axis in order to see the reference line on the chart.

• ###### Re: calculation sum of values in graph

Thanx! works perfectly.

regards

Per