WebChart just have limited chart features compared to Microsoft Excel, But we can export data to an Excel file and do more analyze. It require you download Apache POI packages and put it to the tomcat common library directory.
c:\TomcatWebChart\common\lib
/TomcatWebChart/common/lib
Take the second query in feature overview page.
SELECT Dname, empno, ename, job,
to_char(hiredate,'yyyy/mm/dd') hiredate
from dept, emp
where dept.deptno = emp.deptno order by dname
Click the download data to excel link, you will get an excel file, and it looks as following.
It took me quite a long time to add this feature.
