skip to content »

Updating distances in dynamic graphs

Instructions for creating the dynamic range for the labels in column A follow.

updating distances in dynamic graphs-53updating distances in dynamic graphs-12

When either is the case, there's a more complex formula method.Dijkstra's algorithm to find the shortest path between a and b.It picks the unvisited vertex with the lowest distance, calculates the distance through it to each unvisited neighbor, and updates the neighbor's distance if smaller.For a dynamic chart technique that takes a different route, read Create a dynamic Excel chart and make your own dashboard.Excel worksheets demonstrating these versions of dynamic charting are available as a free download.Mark visited (set to red) when done with neighbors. but a more common variant fixes a single node as the "source" node and finds shortest paths from the source to all other nodes in the graph, producing a shortest-path tree.

is an algorithm for finding the shortest paths between nodes in a graph, which may represent, for example, road networks. For a given source node in the graph, the algorithm finds the shortest path between that node and every other.

If you skip rows or columns, this technique won't work as expected. Because the chart defaults will use the label headings in each column for each series name, you can't use those labels to name the dynamic ranges.

You might be wondering why I added the Series label to each range name. Don't use the same labels for both your spreadsheet headings and your dynamic range names. If you enter new data, the chart won't yet reflect it. Next, update the chart's axis labels (column A), as follows: You don't have to update February; Excel does that for you.

To create the dynamic range for column A, do the following: Notice that first range reference starts with row 2. The second set of references refers to the entire column, enabling the formula to accommodate all values in the column, not just a specific range.

The addition of the -1 component eliminates the heading cell from the count.

I know how to get vba open off the developer tab, but thats about it.