Author Topic: Drawing Crow's foot diagram from Excel data file  (Read 247 times)

0 Members and 1 Guest are viewing this topic.

jaryszek

  • Jr. Member
  • **
  • Posts: 25
Drawing Crow's foot diagram from Excel data file
« on: November 30, 2018, 02:53:44 AM »
Hi,

cross posted from here:

https://social.technet.microsoft.com/Forums/office/en-US/f84e8135-854f-4192-8658-1e3651ccb021/drawing-crows-foot-diagram-from-excel-data-file?forum=visiogeneral

i have pattern like below and i would like to draw crow's foot diagram from this.

Please help how to do it.
Best,
Jacek

Yacine

  • Hero Member
  • *****
  • Posts: 2580
Re: Drawing Crow's foot diagram from Excel data file
« Reply #1 on: November 30, 2018, 05:31:28 AM »
Hello Jacek,

my advice would be to dissect the task in smaller ones (e.g. draw an entity, set its name, its ID, position it, etc.). The necessary commands can be found by recording your own actions with the macro recorder.
Next you would find out how to edit the attributes and how to add relation connectors between the attributes.

Working with the macro recorder requires some basic knowledge like:
- differentiating between important stuff and "decorations". For instance you usually don't need the diagram services stuff, nor the undo functions.
- understand that "ActiveWindow.Select Application.ActiveWindow.Page.Shapes.ItemFromID(223)" is only a shape object that can be defined otherwise (like " set shp = activewindow.selection(1) ").


HTH,
Y.
Yacine

jaryszek

  • Jr. Member
  • **
  • Posts: 25
Re: Drawing Crow's foot diagram from Excel data file
« Reply #2 on: December 03, 2018, 01:37:31 AM »
Hi Yacine,

thank you.

I will create new topics for it.

Best,
Jacek