I need some help with the syntax for an trend line expression in an stacked bar chart.
I have chosen a combo chart with stacked bars. My plan is to have one more expression with the trend line as a line chart but I don't seem to get the syntax right. (The usual trend line function doesn't seem to work when the bars are stacked.)
The bares shows stacked sales for segments per month and I want the trend line to show where the total sales trend is heading for the chosen periods.
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.
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?