2 sheets tagged with "graph":

This example shows you how to do several things:

- Download a file from a Web server for inclusion in your workbook.
- Split the contents of a file up and put it into a worksheet.
- Write a simple and easy-to-understand piece of code to generate a column from other columns.
- Display a stacked bar chart.

It analyses (made up!) data similar to the data that Resolver Systems gets when a user agrees to send usage data in Resolver One. This data is stored as a csv file on a server. The spreadsheet downloads the data, inserts it into a worksheet and draws a graph.

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.