Linear time axis on line chart

[Michelle]

Hello, I want to have a linear time axis along the bottom of my chart, and
to display some values associated with a series of events and to have their
position on the axis grouped and spaced by the time that they occured.

This means that if I had three things happen at 9:15, 9:30 and 10:00 on
monday, then another event at 9:00 on Tuesday, the values for the first
three would appear in quite close proximity along the axis, then a fairly
large gap before the next one. - does that make sense?

I can nearly get what I want with a scatter chart, but some of the events
will have one or two of the associated values missing and the scatter chart
leaves a gap where there is no value, instead of just linking it up with a
line to/from the previous one. And I need to show a continuous trend.

Is this possible?

Thank you for your help.

M

 

[Shane Devenshire]

Hi,

Since you have both dates and times and you want the spacing to reflect the
temporial nature of the data your best choice is probably scatter. Now
select the chart and choose Tools, Options, Chart tab, and set Plot empty
cells as Interpolated.


If this helps, please click the Yes button.

Cheers,
Shane Devenshire