Forum Discussion

JayG7's avatar
JayG7
Copper Contributor
Jan 16, 2019

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

  • AfonsoRod's avatar
    AfonsoRod
    Copper 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?