Histograms in the grid
Uploaded by tom_wright.
Resolver One version 1.6 comes with ZedGraph installed by default. This, together with the expanded cells and image rendering in the grid allows you to create and display graphics using only formulae. Such images will automatically update in response to changes in the grid.
This spreadsheet is a simple example of this. It defines a single user code function which draws a histogram using ZedGraph and returns an image of it. This function is called on CellRanges in a formula - and an expanded cell is then used to display the entire image.
This is one of the sample spreadsheets that come with Resolver One.
This model has been created for Resolver One, an advanced spreadsheet. You can download Resolver One here.