Forum Discussion
JayG7
Jan 16, 2019Copper Contributor
Duplicate Entries Different Columns
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
- AfonsoRodCopper Contributor
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?