Automatically insert rows on worksheet linked to Pivot Table

SergeiBaklan I am perfectly content to go with your opinion on the matter.  I only very rarely get involved with data analysis and on those occasions that I do, I spend too much time fighting with PT defaults that I don't want.  Added to that, I always forget the need to refresh the data at least once.

What I did remember was that GETPIVOTDATA (now working as a dynamic array formula) was more reliable than trying to address cells directly and gave me scatter charts as well as bar charts that held their formatting when series disappeared.  Now I tend to ignore pivot tables and use dynamic arrays but that is merely a reflection of the work I encounter, given the need or opportunity I rather like exploring Power Query.