Adding Trend Lines to a Bar Chart

[krubi]

I would like to add a trend line to a bar chart that I have created.  There are only six bars so it's a very simple chart, but I've never added a trend line before. 

There are several posts about adding a trend line via Chart Annotations -> Baselines, but I'm not sure where I need to go from there.  I don't want a Mean.

Thanks!

[AussiePete2011]

Hi there

Check this out
https://www-304.ibm.com/support/docview.wss?uid=swg21340501

Also of some relevance is
http://www.ibm.com/developerworks/data/library/cognos/page260.html
http://www.ibm.com/developerworks/data/library/cognos/page102.html

Hope this helps
Cheers
Peter B

[krubi]

Thanks Peter!

I understand how this works mathematically, but I'm not sure how to implement this in Cognos.  From the code you provided, it looks like I should create a data item called "Y".  How do I reflect "Y" in my chart? 

Kim

[krubi]

After looking at the code again...

I'm creating 3 data items - X, Y, and Y'.  Then do I add Y' as a series?

Kim

[AussiePete2011]

Hi Kim,

Depending on how you want the measure to be dissected, you would use the Series for Y..

Here's a nice example of using series in a chart
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/topic/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id4467cr_rptstd_reptyp_example_create_colu.html#cr_rptstd_reptyp_example_create_column_chart_plot_order_trends

Let me know if I've gone off on a tangent
Cheers
Peter B