Excel Formula - Help Needed

[lewes]

Im after a bit of help, please !!!

Ive got to work out the break even point after improvements have taken place. Ive done BEP before but never in Excel 2007. I have tried but its not playing ball.

I am highlighting the three columns and then clicking the INSERT tab and the LINE CHART.

What am I doing wrong as on my chart Year 0 isnt at Cost 500 but its at Yr 1.



Three columns - year, cost and benefit

Year
0
1
2
3
4
5
6
7
8

Cost
500
1000
1500
1750
2000
2200
2400
2500
2600

Benefit
0
300
600
900
1400
2000
2700
3400
4200

Thanks for any help and input

[Liszt]

It's plotting the years as a line of 0 Y axis value.

Use the data as Cost and benefit. Right click on a plotted line and select source data. Select Series tab and use select the category X Axis and use you Year column to populate.