+ Reply to Thread
Results 1 to 4 of 4

Trend Data Representation: which chart?

  1. #1
    Registered User
    Join Date
    08-16-2008
    Location
    france
    Posts
    15

    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

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Aren't you missing some data? Iteration 1 totals 95%, and the others 83%, 60%, and 55%.

  3. #3
    Registered User
    Join Date
    08-16-2008
    Location
    france
    Posts
    15
    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

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Chart aside, you can compute the average production time with a formula.
    Please Login or Register  to view this content.
    The formula in B6 and copied across is =SUMPRODUCT($A$2:$A$5 * B2:B5)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort and chart multiple series from raw data using macros
    By RoseyCindy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2008, 05:56 PM
  2. How can I speed up this slow macro?
    By rs2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2008, 08:34 PM
  3. Forcing a chart to plot only relevant data entries
    By Sam Gregoir in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-07-2008, 07:02 AM
  4. Chart - Data Labels
    By Cecil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-09-2008, 06:47 PM
  5. Chart needs to grow with new data automatically
    By markdill in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-07-2007, 08:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1