Chart/Graph

[tvisgod]

I have a column of dates. These are the first ten cells in the column:
<table border="0" cellpadding="0" cellspacing="0" width="103"><colgroup><col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt; width:77pt" align="right" height="20" width="103">8/5/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/6/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/6/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/6/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/6/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/6/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/10/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/10/1993</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" align="right" height="20">8/10/1993</td> </tr> </tbody></table>
The column is actually 170,000 cells long. I would like a chart that demonstrates how often certain dates come up. Specifically, spikes (where a date comes up fifteen or more times in a row) or troughs (where eight or nine dates are skipped) should be represented.

Is this possible? Do I just have too many cells? If so, is there a way to group them by month or some other time period (one entry for August, 1993, for instance). How might I go about doing any of this? I am a real chart/graph novice.

 

[CWatts]

When you're grouping, select both Months and Years from the group box which will keep things in order. You'll then have a new field in your row value titled years.

You can keep it there if you want to see yearly summaries, but you can also move the "years" section up to the Filters box so you can see only a year of data at a time.