+ Reply to Thread
Results 1 to 4 of 4

how do i plot a saw tooth graph?

  1. #1
    zen
    Guest

    how do i plot a saw tooth graph?

    i want to plot a saw tooth graph. this is like an inventory graph where there
    is production and instantaneous consumpltion


  2. #2
    Barb Reinhardt
    Guest

    Re: how do i plot a saw tooth graph?

    Can you give an example of the type of data that you want to plot?

    "zen" <zen@discussions.microsoft.com> wrote in message
    news:42916E5E-7098-471B-8AE8-CFBCBF6F3A8C@microsoft.com...
    > i want to plot a saw tooth graph. this is like an inventory graph where

    there
    > is production and instantaneous consumpltion
    >




  3. #3
    John Mansfield
    Guest

    RE: how do i plot a saw tooth graph?

    Zen,

    Assuming the data label "A" resides in cell A1, you can set up a simple
    sawtooth pattern by using an XY Scatter chart with your data set up as
    follows:

    A B C D Y
    1,000 5,000 5,000 9,000 0.5
    1,000 4,000 5,000 8,000 1.5
    1,000 3,000 5,000 7,000 2.5
    1,000 2,000 5,000 6,000 3.5
    1,000 1,000 5,000 5,000 4.5

    Assume the sheet name is "st". Create an XY Scatter chart.

    The first series is a vertical line . . .

    The X values are:
    =st!$A$2:$A$6

    The Y values are:
    =st!$E$2:$E$6

    The second series is a diagonal line . . .

    The X values are:
    =st!$B$2:$B$6

    The Y values are:
    =st!$E$2:$E$6

    The third series is a vertical line . . .

    The X values are:
    =st!$C$2:$C$6

    The Y values are:
    =st!$E$2:$E$6

    The fourth series is a diagonal line . . .

    The X values are:
    =st!$D$2:$D$6

    The Y values are:
    =st!$E$2:$E$6

    And so on . . .

    Given this logic, you should be able to set up an XY chart to show inventory
    additions, consumption, and trigger points for reordering.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com



    "zen" wrote:

    > i want to plot a saw tooth graph. this is like an inventory graph where there
    > is production and instantaneous consumpltion
    >


  4. #4
    John Mansfield
    Guest

    RE: how do i plot a saw tooth graph?

    Zen,

    A much better way to create the sawtooth graph is to set your data up like
    this:

    Inventory
    1/1/05 5,000
    1/2/05 4,000
    1/3/05 3,000
    1/4/05 2,000
    1/5/05 1,000
    1/5/05 5,000
    1/6/05 4,000
    1/7/05 3,000
    1/8/05 2,000
    1/9/05 1,000
    1/9/05 5,000
    1/10/05 4,000
    1/11/05 3,000
    1/12/05 2,000
    1/13/05 1,000

    Create a simple line chart with your X-axis formatted as dates. Please note
    the duplicated dates at 01/05 and 01/09 that include the maximum and minimum
    inventory values. The duplicated dates effectively create the sawtooth.
    Sorry I didn't create this before my previous post.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com




    "zen" wrote:

    > i want to plot a saw tooth graph. this is like an inventory graph where there
    > is production and instantaneous consumpltion
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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