Insert a line at zero value in a line graph

Hello,

I need to add a line at 0 axis with a line graph having positive and negative values, can someone please help! thanks.

Do you mean,

1) Creating a dummy series in a new column that is all zero values,

or,

2) Changing the formatting/layout of the chart to have a line at the zero-value?

The second option, need to show a line at zero value.

thanks for your help!

bobby

Can you post the spreadsheet you're having trouble with? I don't see why this is a problem--it should be automatic--so I would like to look at what you've got to figure it out.

Hi Ben_hensel,
attached is the sample work sheet.

thanks

Here you go...
Example Graph+.xlsx