how to create 0 to 0 value charts
 

how can i create a chart that for the values that start say for example from
0 for a speed of 1000 and then revolve through different values of speed.
these values values when plotted initially start from 0 for 1000 and reach a
highest value at say 4000 and return back to 0 at 1000 speed. say that values
if they look like these,
1000 0
1400 7
1500 680000
1800 0
2000 650000
2500 660000
3000 750000
3100 800000
3400 0
3500 0
3700 0
3800 0
4000 0
4300 0
4500 0
5000 0
5300 0
5500 0
5700 0
6000 0
6000 0
5700 0
5500 0
5300 0
5000 0
4500 0
4300 0
4000 0
3800 0
3700 0
3500 0
3400 0
3100 0
3000 850000
2500 900000
2000 810000
1800 0
1500 710000
1400 0
1000 0

please let me know how to draw a chart for the same ASAP.

how to create 0 to 0 value charts
 

You could just select the data and create an XY chart. The ascending and
descending parts of the data will overlay each other. To distinguish
ascending and descending, select the first half of the data, make the XY
chart, then copy the second half of the data, select the chart, and use Edit
menu Paste Special to add the data as a new series (not new points).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vamsi" wrote in message
...
how can i create a chart that for the values that start say for example
from
0 for a speed of 1000 and then revolve through different values of speed.
these values values when plotted initially start from 0 for 1000 and reach
a
highest value at say 4000 and return back to 0 at 1000 speed. say that
values
if they look like these,
1000 0
1400 7
1500 680000
1800 0
2000 650000
2500 660000
3000 750000
3100 800000
3400 0
3500 0
3700 0
3800 0
4000 0
4300 0
4500 0
5000 0
5300 0
5500 0
5700 0
6000 0
6000 0
5700 0
5500 0
5300 0
5000 0
4500 0
4300 0
4000 0
3800 0
3700 0
3500 0
3400 0
3100 0
3000 850000
2500 900000
2000 810000
1800 0
1500 710000
1400 0
1000 0

please let me know how to draw a chart for the same ASAP.