Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time-date chart plotting | Charts and Charting in Excel | |||
Excel 2003- Charts- date and time format on x-axis of XY chart | Charts and Charting in Excel | |||
How chart time scale x-axis with another date serie | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Chart with x-axis as date/time | Charts and Charting in Excel |