7 Replies Latest reply: Apr 12, 2010 5:26 AM by Zandra RSS

    Trend line for a stacked bar chart



      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.