Plotting Date and Time on the same chart axis

  • Thread starter Thread starter mccredda
  • Start date Start date
M

mccredda

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I put words as the Y axis values? 0
Scatter plot 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Horizontal axis to the bottom 1
xy scatter - dates off 4
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Customised Axis Values 2
Plot a time series on the x-axis and categories on the y-axis 3

Back
Top