Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create professional charts Sarah Charts and Charting in Excel 1 June 20th 07 07:13 PM
please help... how to create org charts via VBA... [email protected] Charts and Charting in Excel 0 December 29th 06 09:22 PM
Macro to create charts? Ed Charts and Charting in Excel 2 September 25th 06 08:49 PM
how do i create 4 pie charts Mike Kim Charts and Charting in Excel 1 February 21st 06 10:22 AM
I want to create 4 pie charts in a line Shweta Charts and Charting in Excel 1 July 5th 05 08:32 AM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"