Hello,
I have 4 divisions that submit multiple files. I'm tracking this in a basic excel tracking sheet. I would like to reflect how often each division is late or on time in pie charts. How can I do this?
Thank you!
Hello,
I have 4 divisions that submit multiple files. I'm tracking this in a basic excel tracking sheet. I would like to reflect how often each division is late or on time in pie charts. How can I do this?
Thank you!
Not much to go on. Here's how I would expect it to happen. If you need help with specific steps, be sure to provide some specific details about your spreadsheet and the desired solution. Here's how I would expect it to be done.
1) Somewhere in your database/tracking sheet would be a field for "late or on time".
1a) If this field does not already exist in the database, then you can add it. Exactly how to do that will depend on the exact data you have and how you want to designate "late" and "on time".
2) Summarize the "late/on time" field. This might be easiest with a pivot table or with a COUNTIF()/COUNTIFS() function. https://support.office.com/en-us/art...__toc309306716
3) I would expect a result like. Then use that range to create the pie chart.Please Login or Register to view this content.
4) I would expect individual pie charts for each division.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks