Chart "days of the week frequency" from list of dates?

[404error]

say i have a list of dates:

8/1/2011
8/8/2011
8/15/2011
8/10/2011
8/17/2011
8/26/2011

is there anyway that i could, (easily) make a chart depicting the days of the week that the dates fell/fall on...

so (with this data) the chart would have 3 bars, one representing Monday with 3 'occurrences' , one for Wednesday with 2 'occurrences' and one for Friday with 1 'occurrence'

 

[Steve=True]

Easiest way is to do the following:

Go to the area you want the data for your chart Lets Say Column G:

Column G
g1=Sunday
g2=Monday
g3=Tuesday...
g7=Saturday

Column H (This sums the date data and counts each weekday):
Copy this formula from H1:h&

=IF(SUMPRODUCT(--((WEEKDAY( PUT YOUR DATE DATA RANGE HERE )=(ROW($A1)))))=0,NA(),SUMPRODUCT(--((WEEKDAY( PUT YOUR DATE DATA RANGE HERE )=(ROW($A1))))))

Highlight G1-h7

Insert your chart

Steve=True
www.exceldashboardtemplates.com