Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanx! works perfectly.
regards
Per