Chart/Graphing problems

[pooadrid]

i am working with two sets of information.

each set has 13 values for 1 person. and this is for 13 week period.

Person 1 Person 1
Dollars Volume
10 1
20 2
30 3
40 4
50 5
60 6
70 7
80 8
90 9
100 10
110 11
120 12
130 13


I am trying to get this into a graph that shows something like this attachment.

am i missing some formula to show profit and volume over time in some on liner

?

 

[TheMathLab]

Hi Pooadrid

Have you tried a "scatter plot with smooth lines"?
Your data won't give you a plot like the one shown because your data is linear - it'll give you a straight line.

 

[pooadrid]

sorry that was just example.
what i really

am trying to accomplish
is using this information to graph this


in some sort of form of this


where there is one line for one person (the data provided). obviously the data provided shows up to 5 weeks so even if that isnt necessarily on the graph, i am sure there will be indicators some how on it showing how time has passed?
am i going about this the wrong way?