Based on the below date I would like to know how I can graph in excel
the following info.

1) A bid distribution graph for the month by price

Check in 	CheckO	# of Nights	Offered Rate	Total Revenue
4/1/03	4/2/03	1	$40	$40
4/1/03	4/2/03	1	$50	$50
4/1/03	4/2/03	1	$75	$75
4/1/03	4/2/03	1	$99	$99
4/1/03	4/2/03	1	$125	$125
4/1/03	4/2/03	1	$125	$125
4/1/03	4/2/03	1	$125	$125
4/1/03	4/3/03	2	$20	$40
4/1/03	4/3/03	2	$33	$66
4/1/03	4/3/03	2	$35	$70
4/1/03	4/3/03	2	$37	$74
4/1/03	4/3/03	2	$40	$80
4/1/03	4/3/03	2	$42	$84
4/1/03	4/3/03	2	$75	$150
4/1/03	4/3/03	2	$80	$160
4/1/03	4/3/03	2	$100	$200
4/1/03	4/3/03	2	$100	$200
4/1/03	4/3/03	2	$125	$250
4/1/03	4/3/03	2	$300	$600
4/1/03	4/4/03	3	$50	$150
4/1/03	4/4/03	3	$60	$180
4/1/03	4/4/03	3	$110	$330
4/1/03	4/4/03	3	$200	$600
4/1/03	4/5/03	4	$70	$280
4/1/03	4/5/03	4	$75	$300
4/1/03	4/5/03	4	$75	$300
4/1/03	4/5/03	4	$85	$340
4/1/03	4/5/03	4	$100	$400
4/1/03	4/5/03	4	$105	$420
4/1/03	4/5/03	4	$110	$440
4/1/03	4/5/03	4	$125	$500
4/1/03	4/5/03	4	$125	$500
4/1/03	4/5/03	4	$130	$520
4/1/03	4/5/03	4	$135	$540
4/1/03	4/5/03	4	$150	$600
4/1/03	4/5/03	4	$160	$640
4/1/03	4/5/03	4	$160	$640
4/1/03	4/5/03	4	$170	$680
4/1/03	4/5/03	4	$175	$700
4/1/03	4/5/03	4	$180	$720
4/1/03	4/6/03	5	$95	$475
4/1/03	4/6/03	5	$99	$495
4/1/03	4/7/03	6	$125	$750
4/1/03	4/7/03	6	$135	$810
4/1/03	4/8/03	7	$60	$420
4/1/03	4/9/03	8	$50	$400
4/2/03	4/3/03	1	$35	$35
4/2/03	4/3/03	1	$50	$50
4/2/03	4/3/03	1	$65	$65
4/2/03	4/3/03	1	$65	$65
4/2/03	4/3/03	1	$70	$70