Time for action - connecting from Excel to create reports and charts
You are going to create your Monthly Expenses report and also display it as a chart. This will give you the flexibility to extend reporting and charting capability beyond what is available in the canned GnuCash reports.
- Prerequisites: Make sure that you have saved your MACS accounts as a SQLite3 database from GnuCash.
- Prerequisites: Make sure that you have Microsoft Office Excel installed on your system. This tutorial and the screenshots are based on Excel 2003 running on Windows XP. If you have a different version or another operating system, then please look for the equivalent steps.
- Prerequisites: In order to connect to this SQLite3 database from Excel, you need an ODBC driver. ...