how do i plot a saw tooth graph?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to plot a saw tooth graph. this is like an inventory graph where there
is production and instantaneous consumpltion
 
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.
 
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.
 
Back
Top