| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
creating a directed graph from XY scatter
Would like to use XL to create a connected graph ( finance calls it a
binomial lattice). X axis iis the time period t=1,2,3,...T, Y is value. XY scatter plots points OK. Need to connect points (nodes)--each node except for t=T has two lines coming out of it. A 3-peiod example is shown below. Eventually need to generalilze. Data is reference T Value NOde 1... 0 100 NODE 2... 1 110 NODE 3... 1 90 NODE 4... 2 121 NODE 5... 2 100 NODE 6... 2 81 FOR NOW: want a line to connect NODE 1 to NODE 2 want a line to connect NODE 1 to NODE 3 want a line to connect NODE 2 to NODE 4 want a line to connect NODE 2 to NODE 5 want a line to connect NODE 3 to NODE 5 want a line to connect NODE 3 to NODE 6 Suggestions would be greatly appreciated. Luke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I plot an XY (scatter) graph with two Y axes? | Charts and Charting in Excel | |||
| Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
| xy scatter graph with a scrolling time element | Charts and Charting in Excel | |||
| creating names for data shown on a scatter plot | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
