Trend Data Representation: which chart?

babarorhum · #1 08-21-2008, 12:50 PM

Hello,

I am looking for the best way to represent the trend that my following data indicates. However, i am still in doubt about the chart to choose...could you help ? my data is as follow

Duration Iteration #1 Iteration #2 Iteration #3 Iteration #4

15 5 % 18 % 30 % 40 %

30 35 % 25 % 20 % 10 %

50 55 % 40 % 10 % 5 %

and it means for example that during iteration #1 55 % of the items were being out of factory in a period from 30-50 days, 35 % between 15 and 30 days, etc...

whereas iteration #2 had only 40 % of items made between 30-50 days, 25 % between 15-30 days, etc...

What i would like to show on a chart is the trend over iterations that items take less time (duration) to be built. Which chart should i use for that?

Thanks in advance

Antony

**shg** · #2 08-21-2008, 01:05 PM

Aren't you missing some data? Iteration 1 totals 95%, and the others 83%, 60%, and 55%.

babarorhum · #3 08-21-2008, 01:30 PM

Hi !
Sorry i missed the last line.
here it comes:
Duration Iteration #1 Iteration #2 Iteration #3 Iteration #4

15 5 % 18 % 30 % 40 %
30 35 % 25 % 20 % 10 %
50 55 % 40 % 10 % 5 %
60 5 % 17 % 40 % 45 %

Antony

**shg** · #4 08-21-2008, 02:52 PM

Chart aside, you can compute the average production time with a formula.

Code:

      ---A---- --B--- --C--- --D--- --E---
  1     days   Iter 1 Iter 2 Iter 3 Iter 4
  2      15        5%    18%    30%    40%
  3      30       35%    25%    20%    10%
  4      50       55%    40%    10%     5%
  5      60        5%    17%    40%    45%
  6   Average:   41.8   40.4   39.5   38.5

The formula in B6 and copied across is =SUMPRODUCT($A$2:$A$5 * B2:B5)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort and chart multiple series from raw data using macros	RoseyCindy	Excel Programming	0	08-08-2008 06:56 PM
How can I speed up this slow macro?	rs2k	Excel Programming	6	07-18-2008 09:34 PM
Forcing a chart to plot only relevant data entries	Sam Gregoir	Excel Charting	7	07-07-2008 08:02 AM
Chart - Data Labels	Cecil	Excel Charting	1	01-09-2008 06:47 PM
Chart needs to grow with new data automatically	markdill	Excel Charting	3	09-07-2007 09:43 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)