Hi All,

I have got this problem:

I have a series of arrival and departure times which I want to put in a
graphic in Excel.

My problem is that I can't find the right graphic for this data, it's
not a line, bar or circle diagram.

Anyone got ideas how to visualise this data?

Thanks in advance,

Greetings,

Finn

Finn wrote:
Hi All,

I have got this problem:

I have a series of arrival and departure times which I want to put in a
graphic in Excel.

My problem is that I can't find the right graphic for this data, it's
not a line, bar or circle diagram.

Anyone got ideas how to visualise this data?

Thanks in advance,

Greetings,

Finn



Probably depends on what you are trying to show. An XY chart might work.
I played with some random data, with arrivals and departures in separate
series. With x-values of full date-time, and y-values of time-only, you
would be able to see concentrations of arrivals/departures with respect
to time and date.

Hi,

Perhaps you are looking for a gantt chart
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Finn" wrote in message
...
Hi All,

I have got this problem:

I have a series of arrival and departure times which I want to put in a
graphic in Excel.

My problem is that I can't find the right graphic for this data, it's not
a line, bar or circle diagram.

Anyone got ideas how to visualise this data?

Thanks in advance,

Greetings,

Finn

Thanks in advance,

Greetings,

Finn



Hi All & Andy,

This is where I was looking for!

Also was usefull the high/low/opening like for stockdata.

Thanks!

Finn