@natasha11,
Please take a look at this sample project for creating dynamic charts using data from MySQL database in PHP. Also, please refer to this documentation page for creating Dynamically Updating Charts from JSON API & AJAX.
If this doesn’t suit your requirements, kindly share a sample project with sample data over google-drive or onedrive so that we can understand it better and help you out.
—
Vishwas R
Team CanvasJS