Chart problems

[chuckster]

I want to create a chart in Excel showing monthly accident numbers. This should be a line graph that has a running total of the numbers, however I want the data to show a monthly value, with a total at the end. Please help, when I try this I get jumps from month to month, just want an increasing graph line.

 

[PaddyD]

It's not clear what your problem is here -more precisely, you haven't given us enough info to support a diagnosis or remedy.


How about posting back with more about the data you are plotting, how it is set up on the spreadsheet etc

Paddy

 

[Mark W.]

Book1
	A	B	C	D	E	F
1	Month	Value	CumValue
2	Jan	241	241
3	Feb	233	474
4	Mar	96	570
5	Apr	66	636
6	May	135	771
7	Jun	125	896
8	Jul	91	987
9	Aug	245	1232
10	Sep	109	1341
11	Oct	176	1517
12	Nov	198	1715
13	Dec	84	1799
14
Sheet1

This message was edited by Mark W. on 2002-08-29 15:12

 

[chuckster]

As mark W. shows, but I want to create a graph generated from the cumulative column values, but showing just the monthly values in a data table below the graph.