Jan 16 2019 07:33 AM
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!
Jan 16 2019 11:17 AM - edited Jan 16 2019 11:18 AM
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?