Trendline on stacked chart

[Anonymous]

Hey all,

I need some help:

I have a bar chart showing my opportunities revenues over time.

I have also added a reference line to this chart to 800.000 € that represents my yearly target.

I would like to create another reference line that goes from 0 to 800.000€ in December.

Can you please help me on this because i cant find any resource to help me.

Thank you in advance.

Arnaud

[chhavi376]

Hi Arnaud,

Did you try adding it from the 'Reference Line' section in the presentation tab?

You can add an expressions, conditions, according to your requirement.

[Anonymous]

Yes i tried, but i think its more an expression problem because i don't know how to express a trendline starting from 0 and ending in december at 800.000€

[Anonymous]

Hello,

Could you post a sample data?

[Anonymous]

Find here attached an example.

On this chart, i would like to display a fixed reference line that goes from 0 in January 2010 to the other reference line (4500) in december 2010.

I think that my main problem is to define the expression to create the reference line.

Best regards

[awhitfield]

Have you had a play about with Trend lines on he Expressions tab?

Andy

[awhitfield]

Have a look at the attached link:

Re: Forecast Calculation

Andy

[Anonymous]

Dear Andrew,

Thank you for your input but i think that my main problem is to define the expression of the reference line.

It should be a line going from 0 to december - 4500€ (cf the QV sample posted above).

Thank you in advance for your help.