ShortCode with SQL Select on MySQL DB, doesn’t show Chart.

Hi,
I use this plugin for a long-term now using a Google Spreadsheet to get the data.

Now I am testing the SELECT on MySQL DB. The problem is that I get all data really fast and I get the tables with the data elaborated like I want.

But I don’t find a way to show these data with Chart.

I am using shortcodes and queries like these:

[gdoc key=”wordpress” query=”SELECT Action, count(Profit-‘Rollover Fees And Dividends’) AS Closed, sum(Profit-‘Rollover Fees And Dividends’) AS ‘Net Profit’ FROM closed_positions GROUP BY Action” chart=”Area” use_cache=”no”]

[gdoc key=”wordpress” query=”SELECT Date, NWA FROM transactions_report” chart=”Area” use_cache=”no”]

I have not Idea of Why I don’t get a generic Chart.

Is it not permitted to show mysql data by Charts?

Kind regards

G. Aloe