Quarter Values in Chart

[Anonymous]

Hi All,

Have the below Date column and the amount for 2 years ie:

Date               Amt

01/30/2013     100

02/28/2013     200

03/31/2013     300

04/30/2013     400

05/31/2013     500

06/30/2013     600

07/31/2013     700

08/31/2013     800

09/30/2013     900

10/31/2013     1000

11/30/2013     1100

12/31/2013      1200  and so on...

i need to show in the bar chart the Quarter end date and their values for example the output should be same as below:-

Output:-

03/31/2013     300

06/30/2013     600

09/30/2013     900

12/31/2013      1200

Can any one help me on this..

[Anonymous]

Thanks Anand it worked!!!