Report including Charts
There is no special chart support by FlexCel, but again, you just have to send the data to a list in Excel, and the charts will be upgraded to match it. 
Concepts shown
•	Charts might be difficult: Sometimes Excel goes out of its way guessing what you want to do and what are the cells you want to use.  While this is very good in normal situations (Excel almost always gets it right), it gets difficult when you are trying to define a chart out of ##xx## and ...delete row... fields. So a nice trick is to write two rows of real data first, define the chart, and after that substitute the first row of real data with ## fields and the second with a ...delete row...

•	Normally when you create a chart, series remain fixed and the data range expands. In OLE mode, you can also create one serie for each row. To do it, there are 3 steps:
o	1) Create a named range (in this example “ChartData”) incuding the chart data.
o	2) Deselect all, then Ctrl-Click the chart.
o	3) Now you should be able to change the Chart name form the Names combobox. Name it ##ChartData## (in this example)

•	In Ole mode, you can also create a chart completely by program. See the code.

•	Auto filter: This is a nice Excel feature you can use to filter the spreadsheet. Nothing special has to be done; this is automatically supported by Excel.

•	Immobilizing panels: This is another Excel thing, handled without any particularities.