I can think of 2 options Both are dirty solutions, but maybe it's enough for what you need.
Option #1 is creating 2 graphs. One graph has the stacked bar chart and the other has the total linear tendency then you overlay one graph over the other with one graph being transparent and fixing the axes in both graphs so that they match. This is not my favorite option.
Option #2 is creating a expression for every segment and then an expression for the total amount that is invisible, but has the linear tendency activated. An image of Option #2 is attached. This is a decent option as long as you don't have a 1,000 segments.
Good luck, Pover
I have tried your suggestion #2 but I don't get it to work...
The trendline is not visiable, not even if I uncheck the "Invisible" check box.
Are your bars Stacked? Are there any other settings I have to make? I have made sure that my expressions tab looks the same as yours.
Is there anything else I have to do?
Here's the qvw with the graph. Hopefully that will help you find what's missing.
Thanks a lot!
Now I know what my problem was.
I don't want to have the first expression lable as a header on the chart. I solved that by creating an empty expression with no label as the my expression. But that was the issue that caused my trend line not to show up.
I guess there must be a better way to hide the chart header, do you know how?