hello, I'm trying to make a monthly income line graph that can be updated via macro.

I have 2 columns:

price (format example: 568)
date and time (format example: 11/04/2005 12:45:00)

how can i get excel to group the prices for each month to be displayed on a graph?

so x-axis: 'Month', y-axis 'Income that month'

This is like my 3rd thread, and no replies yet.. please help me! Thank you thank you

~ Yours hopefully ~