Thread: Trend Data Representation: which chart?

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

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

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

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)