excel graphing

[chuckster]

I want the make a line graph in excel showing my company's accidents by month. I create my data and use the wizard. My problem: I want the graph line to continually increase with each months additional accidents. My data should relect a particular months total accidents. Just doing a straight forward graph gives me peaks - ie: Jan has 4 accidents and February has 2, normal graph starts its line at 4 and goes to 2, I want the line to start at 4 and go to six. Please help. Thanks.

 

[Mark W.]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Month	Accidents	Cume
2	Jan	4	4
3	Feb	2	6
4	Mar	4	10
5	Apr	1	11
6	May	3	14
7	Jun	5	19
8	Jul	5	24
9	Aug	2	26
10	Sep	1	27
11	Oct	4	31
12	Nov	1	32
13	Dec	1	33
Sheet1

 

[chuckster]

Very nice graph Mark W., but I am not sure how to use it. Please explain.

 

[Mark W.]

Select the data and use the Chart Wizard. Delete the 1st data series (Accidents) if desired.

 

[chuckster]

OK. I think I left out that I want the data to show in a data table at the bottom of the graph. Data table should represent monthly data, but graph should show the cumulative values.

 

[Mark W.]

A chart's data table displays the data that is graphed.

 

[applebyd]

One method would be to chart both the Monthly and cumulative.

Set the line colour for the monthly to the same as the background and delete the reference in the Key.

HTH
DaveA

:wink:

 

[applebyd]

One method would be to chart both the Monthly and cumulative.

Set the line colour for the monthly to the same as the background and delete the reference in the Key.

HTH
DaveA

:wink:

 

[applebyd]

One method would be to chart both the Monthly and cumulative.

Set the line colour for the monthly to the same as the background and delete the reference in the Key.

You can then use the Data Table

HTH
DaveA

:wink: