bar and line chart

[#1]

Hello Experts!

I have a bar chart that is showing the procent per month of my values. The dimension is the month so for one year i have 12 steps. (Jan ... Dec)

What i want to do is to complete this chart with a line where this line should start from the value in jan. and ends linearly at the predifined goal of 80%.

I can't manage the set analysis to take only jan value and then draw a linear line toward the goal (80) in dec.

if my jan. value is A then the line equation should be:

y = (80-A) X/11 + (12*A -80) (ofcourse with jan. as the first value and not at the origin, X is my diemension = month)

Any ideas???

[#2 · Accepted solution]

Hi,

I have created a variable called vJan that stores the value for January. Then I use the following expression to achieve the result you are looking for -

=$(vJan)+(((0.8-$(vJan))/11)*(RowNo()-1))

I hope this helps

Thanks

Nick