Duplicate Entries Different Columns

Copper Contributor

Hello,

I have a very large spreadsheet showing details for each article a patron requests (Journal Title/Date/Patron etc). I want to create a chart that shows how many times each journal is requested per year. 
I'm assuming I do this in a pivot chart, but I have no idea how to show that information properly!

1 Reply

I think you can do it easily if you convert your data into a dynamic table. Can you post a pic with part of your spreadsheet so I can try to better understand what you want to do?