Hi all,

I am currently working on some mock-up data on a survey and create a sample dashboard in excel for my colleagues to use and see the demographics.

I have the data in the same workbook right now and I think they will add more data as time goes on with more survey answers.

What is the best approach if they were to add more answer(data) in the future? or just some general tips for a smoother running excel file?

Thanks in advance.