I have the following data in a work sheet titled "Marathon"
----------------------------------------------------------
Category Date Amount
MARATHON 12/25/2006 $(13.44)
AMOCO OIL 1/23/2007 $(5.00)
SHELL OIL 9/25/2007 -$26.26

I want the macro to do the following
-------------------------------------
1) Create a bar chart that plots
Y- axis amount in dollars
X - axis , months

where for example

Dec-2006 ---the dollar amount will be all the charges totaled up for that month

etc