I am trying to use the line graph facility in Excel 2016. It works perfectly with three or fewer rows of data, but goes nuts with more than 3. Is this a limitation on the graphing facility, or is there a more advanced set of options that must be invoked?

Please attach your sheet. You should be able to put several lines on a graph though it's generally not advisable to put more than three or four for the sake of clarity.