6 Replies Latest reply: Aug 4, 2016 8:05 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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.