Continuous dates and time

Stonleyoh · January 27th, 2006, 09:12 PM posted to microsoft.public.excel.charting

I have a instrument collecting data every minutes for many days (20 days). I
would like to plot a line graph; however, I can not show the date and time in
the chart. I do not want to show all the dates and time but I would like to
show at least 4 to 8 dates and time per day. Any suggestion?

James Silverton · January 27th, 2006, 09:49 PM posted to microsoft.public.excel.charting

Stonleyoh wrote on Fri, 27 Jan 2006 13:12:27 -0800:

S I have a instrument collecting data every minutes for many
S days (20 days). I would like to plot a line graph; however,
S I can not show the date and time in the chart. I do not
S want to show all the dates and time but I would like to show
S at least 4 to 8 dates and time per day. Any suggestion?

Would not a real numerical graph (Scatter Chart not Line Chart)
do the job? A quick and dirty try looks quite well to me. You
can place minor value tick marks every 6 hours, say.

James Silverton
Potomac, Maryland.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate elapsed time between dates and times	Jenna	Worksheet Functions	2	January 25th, 2006 04:39 PM
How to create command button to save the dates and time	Ken Vo	General Discussion	6	January 5th, 2006 04:18 AM
Calculating time between two dates	J. Gutierrez	General Discussion	2	October 21st, 2005 05:53 PM
Time difference between dates	juicegully	Running & Setting Up Queries	8	August 22nd, 2005 06:25 PM
Use first record found in expression?	CASJAS	Running & Setting Up Queries	17	July 22nd, 2004 09:21 PM