Stumped on how to generate excel file, with curve diagrams, through t-sql

My employer, have a customer, that once a month wants an excel file, with our collected data, where it's entered in a curve diagram. The employer said that it should be feasible with t-sql as a stored procedure, for the customer to call, where it will generate the file. I have been searching and looking for a couple of days, and have primarily only found solutions with sp_makewebtask, and have tried to make it work, with no success at all, and as I'm rather stumped, I wondered if it might be you knew of a way, and perhaps could guide me?

Many regards,

Tobias