LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Discretionary X-axis (for date & time)

Hi,

Im trying to plot some stock price data in a graph but running into the
following problem:

The data i want to plot is non continuous, i.e. the datetime should stop at
5.30 pm and continu on 9 pm the next day. When i try to do that with a
scatter or line graph, it does not work.

I guess one workaround would be to make an additional series that translates
the date & time to e.g. 1, 2, 3 ,etc leaving out the dates& times i dont
want to show. Tried this and it seems to work except for the fact that the
interval between my datapoints isnt always the same. This makes the scaling
of the graph not correct. (eg time between 2 points is sometimes 5 mins,
and sometime only 1 minute)

any suggestions?


 
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
Hot key for time? Dave in Des Moines Excel Discussion (Misc queries) 1 March 24th 06 03:46 PM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
time scale axis HB1972 Charts and Charting in Excel 1 October 10th 05 03:34 PM
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM


All times are GMT +1. The time now is 03:31 PM.

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

About Us

"It's about Microsoft Excel"