Re: graph with time and date axis

Amarkumar -

This is like a gantt chart. To get a single floating bar, you need to
have two series charted on a horizontal stacked bar chart. The first
series is the date and time corresponding to the arrival time, and the
second is the duration of the stay.

Arrival Length of Stay
Ship 1 7/2/03 10:30 18:00

Use the Chart Wizard to make a stacked bar chart, and select the Series
in Columns option in step 2. When you are done with the chart, there
are two different colored bars. Double click the one corresponding to
the arrival time. On the patterns tab, make it invisible by checking
None for border and area.

You'll want more convenient axis scale parameters than what Excel
usually provides. Double click on the axis and click on the Scale tab.
In any of those boxes, Minimum, Maximum, Major and Minor Spacing, you
can enter a value as date-time (or just time, like HH:MM) and Excel will
convert it into the decimal equivalents it uses.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Amarkumar P V wrote:
> Hai dears
>
> I am trying to draw a graph depicting berthing activities
> of vessels. Following details are available
>
> ETA – expected time of arrival – Date time format –
> mm/dd/yy hh:mm
> BS - Budgeted stay / expected stay of vessel – time
> format - [h] : mm, in the range of 08 00 hrs to 60 00
> hrs.
> ETD – expected time of departure / completion - Date time
> format – mm/dd/yy hh:mm
> (ETD = ETA + BS)
> LOA – Length of vessel
> (If required every vessel have a unique no. )
>
> maximum three vessel can accommodate, total length of the
> 03 vessels can be 600, excluding a gap of 25 meter between
> vessels.
>
> I wants to draw a graph for a specific period, weekly
> basis, say Monday to Sunday,
>
> Is it possible in excel ? Whether x –axis can be divided
> into 3, each of 0 to 24 hrs? activity of one vessel, more
> than 24 hours, can be plotted as the activity of more than
> one day, starting from mid of one day and ending in next
> day of later. I tried to plot graph by using floating
> bars, by going through the knowledge shared by experts
> news group.
>
> Thank you in advance for expert opinions.
>
> amarkumar
>