

Tables of parameters
Graphs If you want to change an existing graph to a different type, simply click on it to activate it, and then click the appropriate graph button. To create a new graph using data from an ImagineIT table, click first on a cell in the column you want to use for the y axis values and then click the appropriate graph button. A new graph can either be a normal Excel graph, or an 'ImagineIT type graph'. Graphs are created as new sheets and you can opt either to place them in a new window or view them in your existing window. An 'Excel graph' is similar to that produced using the Excel Chart Wizard (but with a white background rather than grey so it can be copied and pasted into other documents more readily). An 'ImagineIT graph' also allows you to 'freeze' copies of plots which will not change when the spreadsheet data changes. When values on your spreadsheet change you will then see the resulting changed plot as well as the original frozen one. This is very useful for comparing results under different conditions (different parameter values). With either type of graph, titles, labels for the axes, and series labels will be generated automatically if you have previously identified the rows on the spreadsheet that you want to use for these things (see 'Specify column names and graph labels' above). [On a technical note: Data for drawing ImagineIT
graphs are stored in a separate 'Graph Data Sheet' (GDS for short) so
that it does not confuse your original spreadsheet. You do not ever
need to look at this sheet. Data for Excel graphs, on the
other hand, is linked directly to your spreadsheet in the normal
Excel way, so that all changes in your data are immediately reflected
in your graphs.]
Adding new data to a graph
Changing what is plotted on a graph
Freezing data on a graph so you can make comparisons
Quick pasting tools
Zooming in and out
Displaying formulae or values
Locking and unlocking
Calculating
Iteration Iteration is an advanced feature of Excel which is useful
when the same calculation is to be carried out many times, each time using
the results of the preceding recalculation. It enables 'Monte Carlo'
simulations involving random numbers to be set up in a straightforward
way. For further detials see Advanced
modelling Features.
Deleting unwanted names
Shortened toolbar giving just formatting options
Entering your passcode
Help button
