Charts on Spreadsheets
To add a Chart to the spreadsheet use the Formula One Workbook Designer and select the cells you want charted. Click the Chart button on the Formula One Workbook Designer toolbar and drag a box onto the spreadsheet. You can then double click on the chart to change how it looks visually and how it displays your data.
For example, I have a spreadsheet which has the values for Value 1 through Value 10 which looks like below. Make sure that the cell in Row 1, Column 1 is empty.
To create a Chart from this data, first click on the Formula One Workbook Designer in the spreadsheet which is shown by this icon:
Drag the cells which you want to put into the Chart, click the Chart button and then drag the Chart onto your simulation.