I had this happen in FMP 12 also so clearly either there's a bug (unlikely) or I'm doing something wrong here.
In the data viewer, the ExecuteSQL referenced in the screenshot above (ExecuteSQL ( "Select Value2 as Value2 from SampleExecuteSQLChart ORDER BY VALUE2"; ¶; ¶)), returns this set of numbers below:
So, why is the chart showing all the same value?
Any suggestions would be welcome.
If you are going to use Delimited Data, you need to specify a list of values for both X and Y data series.
Yes, that works.
Appreciate your follow up on this. :)