mperrah
03-28-2007, 06:18 PM
Hello again,
I have to generate a report and anticipating my boss is going to want it often I need to automate as much as possible.
I do a quality control check on a job and fill a spread sheet. The line item that is out of code I write in a comment field. There are 26 fields that may be used. There may be multiple line numbers entered in the comment cell seperated with a comma and a space. I need to pie chart the percentage of each occurence of the line items failing.
For example, if 5 jobs had a fail on item 30 and no other item was an issue the pie would show 100% for item "30". If the jobs had other line items fail they would show the percentage of the total failed items.
The date range for the pie chart is one week at a time. I can filter the data to just show the week I need but splitting out the number of times each item appears and formatting it for the pie chart is tedious.
I'll attach one that I have made as a sample of what I'm trying to automate.
Thank you for your insights
Mark
:bow:
I have to generate a report and anticipating my boss is going to want it often I need to automate as much as possible.
I do a quality control check on a job and fill a spread sheet. The line item that is out of code I write in a comment field. There are 26 fields that may be used. There may be multiple line numbers entered in the comment cell seperated with a comma and a space. I need to pie chart the percentage of each occurence of the line items failing.
For example, if 5 jobs had a fail on item 30 and no other item was an issue the pie would show 100% for item "30". If the jobs had other line items fail they would show the percentage of the total failed items.
The date range for the pie chart is one week at a time. I can filter the data to just show the week I need but splitting out the number of times each item appears and formatting it for the pie chart is tedious.
I'll attach one that I have made as a sample of what I'm trying to automate.
Thank you for your insights
Mark
:bow: