AddChart only drew the first line in a multine chart

Description

I have created a workbook with several worksheets, each worksheet has a table. I inserted a new worksheet to contain a chart of all the tables on the same graph. every time I ran the program, it only created the first line and excel did not generate an error while opening it. when I rename the excel to zip and open the chart1.xml file, I see entries for all the other tables in tag. I am not an expert in excel markup but I can't see any suspicious difference between the entries for the table that was draws and the ones that weren't drawn I am using excel that came with Office 365 Pro Plus on a windows 10 laptop to open the file but I created the workbook and populated it using excelize

the JSON string (with the original worksheet names changed to make it shorter) passed to the AddChart method is:

{"type":"line","dimension":{"width":1200,"height":480},"legend":{"position":"bottom","show_legend_key":false},"title":{"name":"Chart Title"},"series":[{"name":"Summary!$C13","categories":"Summary!B7:C12","values":"Summary!D7:D12"},{"name":"WECA...!C4","categories":"WECA...!B9:C14","values":"WECA...!D9:D14"},{"name":"Sidmach!C4","categories":"Sidmach!B9:C14","values":"Sidmach!D9:D14"},{"name":"BSN!C4","categories":"BSN!B9:C14","values":"BSN!D9:D14"},{"name":"POS!C4","categories":"POS!B9:C14","values":"POS!D9:D14"},{"name":"ENL!C4","categories":"ENL!B9:C14","values":"ENL!D9:D14"},{"name":"SH!C4","categories":"SH!B9:C14","values":"SH!D9:D14"},{"name":"STL!C4","categories":"STL!B9:C14","values":"STL!D9:D$14"}]}