Plotting multiple times against one date succesively for multiple

  • Thread starter Thread starter Mal
  • Start date Start date
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.
 
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

Back
Top