Line Graph Chart Help remove zero from proceeding months.

[Grimm127]

Hi All,

I have a graph line chart. Broken down by Month (Jan-Dec on the horizontal track) tracking sales for this year and last year. I hate the way the graph looks because since I only have sales from Jan to Jun only the other months are showing zero and the bar graph is showing the zeroes.

I've tries several ideas like if cell is zero then "". But nothing works short of me changing the ranges which I don't want to do or deleting the formulas in the cells which I don't want to do either.

Any suggestions?

Thanks!

 

[worthm]

Try this:

Right click the chart and select data and then click on Hidden and Empty Cells. Change from Zero to Gaps. Sometimes this works and sometimes not. Good luck