6 Replies Latest reply: Aug 4, 2016 8:05 PM by PAUL YEO RSS

    Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

    PAUL YEO

      Hi All

       

       

      Chart 1 I want to plot this.  it is a scatter chart Y axis Budget variance % X axis is the sales YTD.

       

       

      Table 1 i have Budget Bariance. at 3th column and YTD sales at 2nd column.

       

       

      I create Chart 2 , all expression are already correct , only Y Axis to  Budget % display wrong.

       

       

      Table 2 show only 2 group achieve target , but the chart 2 display group 1 achieve budget 100%. But from the Table 1 it shown -51% out of budget.

       

       

      Hope some one can advise me.

       

       

       

       

      Paul