I have a list of survey responses and I have created a Pivot Table with Month
as the Row Heading and Count of Respondent as Data. I have then created a
Pivot Table chart.

I want to show a trendline but when I select the columns and right click for
Trendline, as I would normally, the option is greyed out.

How do I create a trendline for the pivot table category columns?