Which platform do you use? You are making nice graphics. It is not easy to do that in excel, unless you have a super computer (excel is so slow). powerbi?
You can use Stata, SPSS, R or Python. If you have good experience with Python, there are packages for you to use (on Python and on R as well).
Excel is not good to play with plots and analyses.
I had problems with this chart as well. Those spikes are probably a data problem as I have them in my charts as well.
You can try with different recasting options (area, line, connected, scatter) and choose an option that gives you best plots.
