HowtoMatrix

While OpenOffice.org Base is good for storing and querying data, it doesn’t provide any easy way to chart information. This is exactly what Calc does best, with its dedicated chart module. If you want to visualize data stored in a Base database, you can write an OOo Basic macro that pulls data from a database, inserts it into a Calc spreadsheet, and then creates a chart. Here’s how.

We can illustrate this exercise with a simple database for managing tasks. It consists of three fields: a Task text field, a Date, and the Status boolean field. The latter field is used to mark finished tasks. The macro retrieves all the tasks and presents finished and unfinished tasks as a chart.

Read more at Linux.com