Plotting multiple series as one

[mluetkem]

I've got a question on how to plot mutliple series as one large scatte
plot with the same x axis values. I have 31 data sets (essentiall
each data set represents data for a day of the month). Each data se
has 24 data points, from time 0:00 to time 23:00. How can I plot al
as one data set (a single data marker) and all have the same time uni
x-axis. Everytime I do a scatter plot the time scale is som
fractional value and not the HH:MM time of day format.

Thanks.

Mik

 

[Jon Peltier]

Mike -

Fractions are how Excel deals with time (fractions of a day, so 12 hours
is equal to 0.5). Double click the X axis, click on the Number tab, and
select one of the HH:MM type formats from the Time category.

You can simply format both series to have the same marker and colors.
Otherwise you'd have to put the Y data into the same column and repeat
the X values (times).

- Jon