Empty values in x axis

[nemis]

Hi, Excel pro's,

I have a problem with x axis values. I need to see all of years in the chart as I see now, but Excel includes all empty cells. But I don't need them, because it looks unpresentable. I tried to uncheck empty values on axis values options, but there too many values, so I can't uncheck them all. I tried to search for a different solution, but I found nothing.
Maybe someone knows a solution how to remove those empty values without messing nice-looking arrangement of years?
Link with printscreen of my chart -> Screenshot by Lightshot
All solutions work with me (formulas, functions etc.)

Thanks in advance!

 

[pbornemeier]

What I have done in a similar situation is code to copy the data to a blank page as values, delete the 0 value columns and create the graph from that page.