M Chart Pro
External Data
Keep a chart’s data in sync with a source hosted elsewhere: a Google Sheets tab, a remote CSV URL, a MySQL database, or another chart on your site, with a scheduled auto-refresh. You never have to re-enter numbers by hand.
See it in action
Point a chart at its source once and the data refreshes on a schedule you choose. A failed sync never touches your existing data, so the chart keeps rendering with the last good numbers.
Five sources
Pick a source per chart. Each one has scheduled auto-refresh (30 minutes to 3 days, or the site default), Sync Now from the editor, and a Sync column on the Charts list that shows OK, Error, or Never.
Google Sheets
Paste a share link and pick one or more tabs. Each tab becomes its own data set. Private sheets work through a Google service account.
Remote CSV
Pull from one or more CSV URLs, named per data set, using your site’s CSV delimiter. Remote hosts are validated to block server-side request forgery.
Local MySQL
Build a chart from read-only SELECT queries against your WordPress database, one query per sheet. Queries run in a read-only transaction with row limits. Admins only.
Remote MySQL
Connect to another MySQL server over SSL and chart the results of read-only SELECT queries. The password is stored encrypted, and you can add a CA certificate. Admins only.
Another Chart
Pick any published chart on your site and use its data as the live source for another chart. Keep one dataset and feed it to as many charts and tables as you like, so the same numbers can be a line chart on one page and a sortable table on another. Saving the source updates every chart built on it, even chains of them. Circular references are blocked, unpublished or password-protected sources are refused, and rows or columns you’ve excluded on the source stay excluded downstream.