Plotting Date and Time on the same chart axis


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

Advertisements

J

Jon Peltier

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
xy scatter - dates off 4
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Customised Axis Values 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
secondary category axis reset to min=0 max=0 on save 1

Top