Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database to diagram
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |