View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Havenstar Havenstar is offline
external usenet poster
 
Posts: 17
Default Create Chart by Counting Number of Times Data is Used

Hi,

I am not sure where to start - so here goes. I have been asked to create a
pie chart on why jobs are shipped late. My table has the following:

Wk Ending Job # Reason
05/06/2006 61058301 Vendor-Vendor Delay
06/17/2006 60883301 Vendor-Vendor Delay
09/09/2006 70143301 Purchasing-Delay in Ordering
10/07/2006 60982301 Materials-Requisitioned Late

I have a standard list of reasons and want to do a count for each reason and
create a pie chart off of the count. Can anyone assist in how to do this?

Thank you
Havenstar