Buiding a Chart.

[Manolocs]

Hello, I am trying to build a chart to show Profits and Loss in the vertical axis and a product price in the horizontal axis.
How can i show a "zero" line in the middle of the vertical axis
To the UP is Profits, down the "zero" line is Loss.
The values of both axis will be the value written in a cell.
The scale of the vertical axis will be:
...-400 -300 -200 -100 "0" 100 200 300 400...
The scale of the horizontal axis starts at "zero" at left of the chart and will be:
0 100 200 300 400...
It should be easier if I could upload a picture of the chart.
Thanks for any help.
Cheers

 

[VoG]

Look here http://peltiertech.com/Excel/Charts/AddLine.html

 

[Manolocs]

Hi VoG, thank you for the link, but is not only a line, I can't make a vertical axis as a positive/negative number, example:
-400 -300 -200 -100 0 100 200 300 400
Cheers,