The Data I am pulling from is:<o></o>
<o> </o>
<tbody>
</tbody><o> </o>
<o></o>I can do basic pivot tables but this has muddled me. I am so new to it all. Please help.
This was my instructions:<o></o>
<o> </o>
I need them placed into graphs showingthe time line from 2010 to present.<o></o>
<o> </o>
We need to measure three areason a monthly bases; frequency of events, total amount of claim for the monthand unit count for the moth. <o></o>
<o> </o>
I need it in a three bar graphand line chart with three spate lines for each measurement.<o></o>
<o> </o>
ATA<o></o> | Claim Amount<o></o> | # Units<o></o> |
11/7/2010<o></o> | $322.89<o></o> | 4<o></o> |
3/29/2011<o></o> | $41.36<o></o> | 24 (4 ctns)<o></o> |
3/4/2011<o></o> | $20.68<o></o> | 12 (2 ctns)<o></o> |
3/24/2011<o></o> | $72.38<o></o> | 42 (7 ctns)<o></o> |
7/29/2011<o></o> | $50.79<o></o> | 2<o></o> |
8/4/2011<o></o> | $101.58<o></o> | 4<o></o> |
8/5/2011<o></o> | $253.96<o></o> | 10 (2 ctns)<o></o> |
12/9/2011<o></o> | $76.19<o></o> | 3 units <o></o> |
12/15/2011<o></o> | $78.36<o></o> | 4 units<o></o> |
9/13/2011<o></o> | $54.42<o></o> | 2<o></o> |
12/13/2011<o></o> | $612.23<o></o> | 25<o></o> |
10/27/2011<o></o> | $24.49<o></o> | 1<o></o> |
3/10/2012<o></o> | $24.49<o></o> | 1<o></o> |
4/18/2012<o></o> | $489.78<o></o> | 20 (4 ctns)<o></o> |
4/16/2012<o></o> | $124.08<o></o> | 72 (12 ctns)<o></o> |
5/8/2012<o></o> | $1,224.45 <o></o> | 50 (10 ctns)<o></o> |
7/1/2012<o></o> | $59.86 <o></o> | 1<o></o> |
7/15/2012<o></o> | $489.78 <o></o> | 20 (4 ctns)<o></o> |
7/17/2012<o></o> | $122.45 <o></o> | 5 (1 ctn)<o></o> |
11/10/2012<o></o> | $119.72 <o></o> | 2 (1ctn)<o></o> |
11/18/2012<o></o> | $199.54 <o></o> | 10 (2 ctns)<o></o> |
10/29/2012<o></o> | $748.82 <o></o> | 192 (32 ctn)<o></o> |
12/6/2012<o></o> | $25.58<o></o> | 1<o></o> |
12/9/2012<o></o> | $25.58<o></o> | 6<o></o> |
12/3/2012<o></o> | $126.98<o></o> | 5<o></o> |
11/4/2012<o></o> | $38.09<o></o> | 3<o></o> |
7/31/2012<o></o> | $122.45<o></o> | 5<o></o> |
2/17/2013<o></o> | $54.42<o></o> | 5<o></o> |
10/26/2012<o></o> | $20.68<o></o> | 12<o></o> |
3/23/2013<o></o> | $982.83<o></o> | 252<o></o> |
4/8/2013<o></o> | $51.15<o></o> | 12<o></o> |
4/3/2013<o></o> | $39.91<o></o> | 2<o></o> |
2/25/2013<o></o> | $54.42<o></o> | 5<o></o> |
3/27/2013<o></o> | $23.40<o></o> | 6<o></o> |
5/20/2013<o></o> | $25.58<o></o> | 6<o></o> |
5/7/2013<o></o> | $49.89<o></o> | 5<o></o> |
6/10/2013<o></o> | $25.58<o></o> | 6<o></o> |
<o></o>I can do basic pivot tables but this has muddled me. I am so new to it all. Please help.
This was my instructions:<o></o>
<o> </o>
I need them placed into graphs showingthe time line from 2010 to present.<o></o>
<o> </o>
We need to measure three areason a monthly bases; frequency of events, total amount of claim for the monthand unit count for the moth. <o></o>
<o> </o>
I need it in a three bar graphand line chart with three spate lines for each measurement.<o></o>