# excel graphing

#### chuckster

##### New Member
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.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Book1
ABCDEFGHIJKLMNOP
1MonthAccidentsCume
2Jan44
3Feb26
4Mar410
5Apr111
6May314
7Jun519
8Jul524
9Aug226
10Sep127
11Oct431
12Nov132
13Dec133
Sheet1

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

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

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.

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

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:

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:

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:

Replies
3
Views
56
Replies
0
Views
306
Replies
3
Views
149
Replies
0
Views
136
Replies
7
Views
123

1,196,181
Messages
6,013,909
Members
441,794
Latest member
Deepakjaat31

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back