LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you create 1 chart that will update based on filtered data? Diane Charts and Charting in Excel 3 August 9th 06 02:30 PM
Create single chart with data from seperate worksheets MATT Charts and Charting in Excel 1 May 10th 06 04:09 AM
how to create chart using data on different worksheets in xls Nilesh Buddha Charts and Charting in Excel 1 March 3rd 06 03:42 AM
How do I create a Pie Chart from a LIST of Data? Jim Kelly Charts and Charting in Excel 1 June 15th 05 03:31 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"