Please help with charting

[roldon1990]

Hi

I have done a bit of reading in the forum, but I am still confused as to how to go about creating a pie or bar chart from qualitative data that is tied to dates. Example Date Column: Monday, February 16, 2016 Activity Column 1: Data Entry Activity Column 2: Meeting Activity Column etc.

I am trying to quantify or average how many times a specific activity is being done by several employees within a week or a month. So if the workers are doing more data entry than consultations, I would like it to be reflected in a chart based on the Excel work logs being submitted to me. Is this possible?

I recently combined 3 sheets of data from 3 employees onto one sheet generic sheet. I will share an attachment as soon as I have permission from this forum to do so.

Thank you!

[tuph]

Hi there. Welcome to the forum! It's always a good idea to attach a sample of your workbook (see link in my signature) so that others can look for solutions without having to re-create your data. Remember to remove or replace any sensitive info before uploading the file.

Good luck with your workbook.

[roldon1990]

Thank you so much for the direction Trish! I will be certain to do just that! Thank you again for your assistance!