View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Database to diagram

You could give each ship a numerical value each day starting with a value of
1 if there is one ship on that date, a 1 and 2 if there are two ships,...

Then plot this set of numbers and dates in a chart with the dates as the
x-axis and the number as the Y-axis. I would try a stacked line plot.

You could also change the markers to little ship pictures.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Crimson King" wrote:

I have a database of ships and loading / discharging dates (and various other
info). Using the information from the database, is it possible to display
diagrammatically, each vessel as a "block" against the same date line with
the click of a button (basically a simple visual schedule).

--
Many Thanks,
CK