how to create 0 to 0 value charts

G

Guest

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top