I create a table with some values and deleted the data in one row. Then, I ran Ideas for Excel. The result is the chart preview shown in the picture below. If I now insert this chart created by Ideas, I get the chart shown on the right side of the screenshot.
So, it seems, that Ideas does not like empty rows or has a problem there. If I, for example, repeat the test by deleting only the data in the first row in the table, Ideas can not suggest a chart.