Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 19th 09, 05:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1
Default Plotting Date and Time on the same chart axis

I'm plotting data on the y-axis of a XY (scatter) chart, but I want to plot
it against time without the time looping back on itself, i.e. i want to have
the x-axis starting at midday on say the 18th of Feb and finishing at the
same time on the 19th of Feb. Is this possible?

At the moment the x-axis runs between midnight to midnight and doesn't
acknowledge the change of date so the data is being mixed up.

  #2   Report Post  
Old February 19th 09, 06:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Plotting Date and Time on the same chart axis

Your data values must contain dates, not just times. You can pick a number
format that doesn't show the date part of the value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"mccredda" wrote in message
...
I'm plotting data on the y-axis of a XY (scatter) chart, but I want to
plot
it against time without the time looping back on itself, i.e. i want to
have
the x-axis starting at midday on say the 18th of Feb and finishing at the
same time on the 19th of Feb. Is this possible?

At the moment the x-axis runs between midnight to midnight and doesn't
acknowledge the change of date so the data is being mixed up.





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
Time-date chart plotting Midjack Charts and Charting in Excel 13 April 10th 10 05:27 PM
Excel 2003- Charts- date and time format on x-axis of XY chart Elizabeth Charts and Charting in Excel 3 October 4th 07 12:08 AM
How chart time scale x-axis with another date serie luvgreen Charts and Charting in Excel 4 November 13th 06 03:32 PM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 11:16 AM
Chart with x-axis as date/time UnderCoverGuy Charts and Charting in Excel 2 September 25th 06 01:44 PM


All times are GMT +1. The time now is 02:05 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017