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
></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> |
<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>
