Does anyone know what's happening to this Stacked Area chart?

[sewercider]

I have a table of weeks, and scores for a number of events which happened that week - Am trying to plot on a stacked area chart to illustrate the momentum, but am running into an interesting thing where the date from one of the weeks (I think) is kind of dragging subsequent weeks along with it (see below).

Screenshot 2022-08-18 112756.png

Where I have put the red arrow, this should be showing a peak (not a dip) as week 5 has the highest event 7 entry?!

Any advice would be greatly appreciated!!!

[MrShorty]

I'm unable to open the file, but the picture looks correct to me. The sum total for events 1 to 7 on week 4 is 0.76. The sum total for the same events on week 5 is 0.37. If week 5 event 7 appears to have a dip, it is because events 1 to 6 are much smaller than week 4. That's just how stacked charts work.

I can't tell how this all fits into your overall project, so I'm not sure what to recommend. My only suggestion is to think carefully about how stacked charts work, what you need to communicate with this chart, and determine if a stacked chart is really what you want.