Pie Chart not appearing

From the plugin FAQ:

Nothing appears where my chart should be.

The best way to determine what’s wrong with a chart that isn’t displaying properly is to try displaying the chart’s data as a simple HTML table (by removing the chart attribute from your shortcode), and seeing what the tabular data source looks like.

Charts most likely fail to display because of a mismatch between the chart you are using and the format of your spreadsheet.

Each type of chart expects to retrieve data with a certain number of rows and/or columns. If your Google Spreadsheet is not already designed to create data for a chart, you might be able to use the query attribute to select only the rows and/or columns that the chart you’re using expects. Otherwise, consider creating a new sheet with the proper formatting and using the gid attribute in your shortcode.

To learn more about the correct spreadsheet formats for each chart type, please refer to Google’s Chart Gallery documentation for the type of chart you are using.

So, the first of your shortcodes (the one with “no chart, no error”) contains a header line. Observe. In contrast, the second one does not.

Have you considered reworking your query to retrieve only the data you want? Refer to the Google Charts Gallery for more information about what data format is expected when using Pie charts.