Which options can be set in an excel sheet?

Question

Is there a tutorial what I can define in an excel sheet?

Here is what I would like to do:

I have a tree with four layers. There is one root node.

So this looks in Excel like:

		Product Backlog
Source	Target	Label
Goal		Goal: There where we want to go.
Activity A	Goal	Do this and that.
Activity B	Goal	Do this and that.
Task A 1	Activity A	Do this and that.
Task A 2	Activity A	Do this and that.
Task A 3	Activity A	Do this and that.
Task B 1	Activity B	Do this and that.
Task B 2	Activity B	Do this and that.
Tool A 1 I	Task A 1	Do this and that.
Tool A 1 II	Task A 1	Do this and that.
Tool A 2 I	Task A 2	Do this and that.
Tool A 2 II	Task A 2	Do this and that.

But I would like to have much more. I want to set the fill color and the font color in the excel sheet, for example #ff9900 and #000000 for the goal or #808000 and #ffffff for the tasks.

Further I would like to set the size of all nodes and the way how the tree is displayed. This should be as a tree in directed style and the leaves stacked on the right side.

Answer 1

I got the most things fixed. I used this table and routed the datas.

 

	Edge List		Node List
Source	Target		Nodename	Label	Width	Height	Background Color	Font Color
Goal			Goal	Goal: There where we want to go.	300	125	#ff9900	#000000
Activity A	Goal		Activity A	Do this and that.	300	125	#99cc00	#000000

There is only the problem that the root node is not displayed correct.

Comments

I'm not sure that you mean by 'the root node is not displayed correct'. However, there is a potential error in your solution: the edge list must contain only real connections, therefore you should remove its first line which has no target node.