• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Month Formula help

D

dudeski

New Member
Hi guys,


Need your help again with a formula/VBA whatever does that trick


https://rapidshare.com/files/3751539526/sample1.xls


Here is the sample worksheet. Basically I need to produce a similar chart to show only four months worth of payments. Each month we will have a new figure and in order to automate this, would it be possible to have a 'current month cell' where I drop the figure...May in this case and Excel automatically moves all the figures back leaving me figures from Feb-May?


If it isn't clear, please let me know
 
Dudeski


Setup 2 Named formula like:


Applied: =OFFSET(Sheet1!$A$3,,COUNTA(Sheet1!$3:$3)-4,1,4)

Paid: =OFFSET(Sheet1!$A$4,,COUNTA(Sheet1!$4:$4)-4,1,4)

Date: =OFFSET(Applied,-1,0)


I would change the Chart to a Scatter Chart first

then

Then edit the Chart so that you will use the Named Formula as the source of the Data

Right Click on the Chart, Select Data

Select the Series eg: Applied

Series X Values: =sample1.xls!Date

Series Values: =sample1.xls!Applied
 
Hi Dudeski,


i have created one file as per your requirement.


Kindly check


http://istiyakshaikh.hpage.com > Dowloads > For_Solution_dudeski.xls


Any query plz let me know.


Regards

!$T!
 
You must log in or register to reply here.
Back
Top