How do I draw charts and load them into a word document?

See more:

C#

MS-Word

I am trying to build a small software to generate reports using the data I obtained from a database.

One of my requirements was to draw charts based on the number of days selected. My initial testing was working fine for a short duration from 1 week's worth of data. When I shifted to upper limit of my requirements I faced the problem of excel telling me that I can only have up to 255 data series.

Are there any other native APIs that I can use to generate the graphs and load them into a word document? I am hoping to keep the same look and feel as the normally generated graphs.

What I have tried:

I have tried using Microsoft.Office.Interop.Word.Chart to draw the charts.
The software crashed when Excel reports that I can only have 255 data sets.

I am also considering using multiple charts with no fills to overlay over the first one to achieve the similar effect but thus far, I have not been able to get the anchor of the first inline chart.