Problem in Stack Bar Chart

[#1]

Hi All,

I am facing issue in Stack bar chart..

Problem: Non - bounce trend line present in the attacehd .qvw is not displaying properly.. can you please let me know what would be the reason..??

I am attaching the sample excel data as well.

Thanks in advance.

-Bas

[Anonymous]

Hi Bas,

The reason is that the non-bounce is a not a continuous value.  

I would use a trendline instead, with absolute values.

Cheers,

ANtoine

[#3]

Hi Antonie,

Thanks for the response.

I tried the solution you have suggested but the reference line is not showing up in the chart. Any idea..?? can you please attach the sample updated .qvw file.? thanks!

-Bas

[Anonymous]

Try to create a new dimension, which is a combination of YearWeek, and sort upon it.