ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Database to diagram (https://www.excelbanter.com/excel-discussion-misc-queries/233643-database-diagram.html)

Crimson King

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

Shane Devenshire[_2_]

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



All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com