How do I create a report for charting without pulling in the primary column?

I have a sheet that includes many years of publications for my department. In trying to report the data to put into a chart in a dashboard, the report keeps pulling the primary column from the sheet. The primary column includes the title of the publication, and makes the chart unusable. Smartsheet says you can choose the data for the chart, but mine doesn't let me. It pulls everything, and I can't highlight only what I want. I only need the count of published publications by year. I tried using a formula in another grid sheet, but the formula didn't work. Can anyone help?