Plotting multiple times against one date succesively for multiple
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. |
Plotting multiple times against one date succesively for multiple
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mal" wrote: 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. |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com