10 Replies Latest reply on May 6, 2016 1:15 PM by Phillip Overpeck

    Scatter Plot (formula help)

    Dario Restrepo

      Hello all,

       

      This question is probably directed to all the data viz wizards out there.   This may be an easy question but I have been trying for about a week without any success.

      What I am trying to accomplish is to create a scatter plot that displays the  year 2015 values for Revenues and Ending Balance at year end.

       

      On the vertical y-axis, I would like to see Ending Balance (at year end - December's balance) and on the horizontal x-axis total Revenues for the full year (sum of all revenues for the year).

       

      The issue that I am having is that for Ending Balance, the value should only show the December 2015 amount, AND NOT give me the total SUM  of all the monthly values for the year.  Since it is an ending balance, it should only reflect the balance at the end of the period. 

       

      ANY HELP IN THIS WOULD BE GREATLY APPRECIATED!~ !!!!!

       

       

      I have attached a workbook with the sample data and scatter plot.

       

      THANK YOU ALL!