Plotting multiple times against one date succesively for multiple

M

Mal

IOW...I have an event that happens multiple irregular times each day. I
would like to do a scatter graph that would show x=dates, y=time hh:mm:ss.
So each data point on x has multiple y's. Is this possible?

I've had no luck thus far and have tried all the usual suspects.
 
L

Luke M

Not exactly sure what trouble you're running into, but this is what I was
able to do:

With no group of cells selection, open the chart wizard, select XY
(scatter) graph. On the next screen, click on the Series tab, Add a series.
Give the series a name (if desired) then select your range of dates as the X
values and the times as the Y values. This then produces a chart with dates
on the x-axis, and allows for multiple y-values per x.
 

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

Top