Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS

i want to create a line chart in excel for rate vs time as y & x axis data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell (rate )
should be taken automatically for charting the chart for 10am to 11.30pm. the
only thing is how to check logically
if the system time reached or not.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS

Put the times in one column and the rates in the next, then create an XY
chart. I can't tell a lot from your post, but if you expect Excel to
determine a rate from the time, it will not. You have to write some formulas
to calculate them (in the second column mentioned above). Is the system time
some kind of limit? Do you need to add a vertical or horizontal line to the
chart?

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


"vijaicbe" wrote in message
...
i want to create a line chart in excel for rate vs time as y & x axis data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell (rate )
should be taken automatically for charting the chart for 10am to 11.30pm.
the
only thing is how to check logically
if the system time reached or not.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X A

Thankyou mr. Jon for giving me a solution, the chart should be generated
automatically by taking a value from one cell determining the time that is if
the time is 10.00am then take a10 value for charting and then if 10.30am
again the value from a10, here the x axis value time should be determined
from system time when it hits that time what ever the value in a10 cell it
should chart it.

can you help me



"Jon Peltier" wrote:

Put the times in one column and the rates in the next, then create an XY
chart. I can't tell a lot from your post, but if you expect Excel to
determine a rate from the time, it will not. You have to write some formulas
to calculate them (in the second column mentioned above). Is the system time
some kind of limit? Do you need to add a vertical or horizontal line to the
chart?

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


"vijaicbe" wrote in message
...
i want to create a line chart in excel for rate vs time as y & x axis data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell (rate )
should be taken automatically for charting the chart for 10am to 11.30pm.
the
only thing is how to check logically
if the system time reached or not.




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X A

Not clear. Describe your data in more detail, and indicate more clearly
which of the data is to plot given a particular value in another cell.

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


"vijaicbe" wrote in message
...
Thankyou mr. Jon for giving me a solution, the chart should be generated
automatically by taking a value from one cell determining the time that is
if
the time is 10.00am then take a10 value for charting and then if 10.30am
again the value from a10, here the x axis value time should be determined
from system time when it hits that time what ever the value in a10 cell it
should chart it.

can you help me



"Jon Peltier" wrote:

Put the times in one column and the rates in the next, then create an XY
chart. I can't tell a lot from your post, but if you expect Excel to
determine a rate from the time, it will not. You have to write some
formulas
to calculate them (in the second column mentioned above). Is the system
time
some kind of limit? Do you need to add a vertical or horizontal line to
the
chart?

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


"vijaicbe" wrote in message
...
i want to create a line chart in excel for rate vs time as y & x axis
data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell
(rate )
should be taken automatically for charting the chart for 10am to
11.30pm.
the
only thing is how to check logically
if the system time reached or not.






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X A

Dear Jon, Tnx for the reply

See i want to draw a price track chart for a product, which onec price
changes minute by minute. for example take gold

by 10am it is costing Rs.9100 (Indian rupee)
by 10.15am it is 9000
by 10.30am it is 9400
by 10.45am it is 8900
..
..
..
..
by 11.30pm it is 9200

Now i want to draw chart where time in x axis and price in y axis
i'll be getting the price value in one cell after some calculation (for
example @ A13). now i can do the chart by posting the price to predefined
value for x axis, but what i want is, when the system time is 10.am or
10.30am or ...., excel should plot the chart automatically by taking the
value from the cell A13. for this i need to check the following

IF SYSTEM TIME = Z (WHERE Z IS 10.00AM ,10.30AM, ... 11.30PM)
CHECK THE VALUE @ CELL A13 AND PLOT THE POINT IN CHART
AS X AXIS VALUE =Z AND Y AXIS VALUE FROM CELL A13

OR

I WANT TO MOVE THE VALUE FROM CELL A13 TO D1,D2,D3...... AUTOMATICALLY WHEN
THE SYSTEM TIME IS 10.10.30......,WHERE
Cxx & Dxx ARE THE VALUES OF X AXIS AND Y AXIS OF MY CHART

| C D
----|--------------------------------------------------
1 | 10.00 9000
2 | 10.30
3 | 11.00
4 | 11.30
5 | 12.00
6 | 12.30
7 | 01.00
8 | 01.30
9 | 02.00
10 | 02.30
..
..
..
..
..
28 | 11.30 9200
-----------------------------------

HOPE NOW YOU MIGHT HAVE A CLEAR IDEA PL HELP ME

THANK YOU
------------------------------------------------------------
"Jon Peltier" wrote:

Not clear. Describe your data in more detail, and indicate more clearly
which of the data is to plot given a particular value in another cell.

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


"vijaicbe" wrote in message
...
Thankyou mr. Jon for giving me a solution, the chart should be generated
automatically by taking a value from one cell determining the time that is
if
the time is 10.00am then take a10 value for charting and then if 10.30am
again the value from a10, here the x axis value time should be determined
from system time when it hits that time what ever the value in a10 cell it
should chart it.

can you help me



"Jon Peltier" wrote:

Put the times in one column and the rates in the next, then create an XY
chart. I can't tell a lot from your post, but if you expect Excel to
determine a rate from the time, it will not. You have to write some
formulas
to calculate them (in the second column mentioned above). Is the system
time
some kind of limit? Do you need to add a vertical or horizontal line to
the
chart?

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


"vijaicbe" wrote in message
...
i want to create a line chart in excel for rate vs time as y & x axis
data.
the chart
should be an automatic charting as, when the particular time
(10,10.30,11,11.30 ...)of system time reaches the data in one cell
(rate )
should be taken automatically for charting the chart for 10am to
11.30pm.
the
only thing is how to check logically
if the system time reached or not.






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
Adding series, this time with a 2 axes line chart Barb Charts and Charting in Excel 1 December 9th 05 09:48 AM
Line chart for churn rates of many items over time Whoops Charts and Charting in Excel 3 August 25th 05 07:26 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
how to show date on the x axis of a line chart? Ginger Charts and Charting in Excel 4 May 1st 05 02:11 AM
Problems with X Axis for a Line Chart Shadowman13 Charts and Charting in Excel 3 February 18th 05 01:15 AM


All times are GMT +1. The time now is 04:11 PM.

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"