Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
Can you give an example of the type of data that you want to plot?
"zen" wrote in message ... i want to plot a saw tooth graph. this is like an inventory graph where there is production and instantaneous consumpltion |
#3
|
|||
|
|||
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 a =st!$A$2:$A$6 The Y values a =st!$E$2:$E$6 The second series is a diagonal line . . . The X values a =st!$B$2:$B$6 The Y values a =st!$E$2:$E$6 The third series is a vertical line . . . The X values a =st!$C$2:$C$6 The Y values a =st!$E$2:$E$6 The fourth series is a diagonal line . . . The X values a =st!$D$2:$D$6 The Y values a =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
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
How do I plot an XY (scatter) graph with two Y axes? | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |