Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create professional charts | Charts and Charting in Excel | |||
please help... how to create org charts via VBA... | Charts and Charting in Excel | |||
Macro to create charts? | Charts and Charting in Excel | |||
how do i create 4 pie charts | Charts and Charting in Excel | |||
I want to create 4 pie charts in a line | Charts and Charting in Excel |