Chart Your Data with FileMaker 11

The main new user feature within FileMaker 11 is its ability to allow you to easily produce charts directly within FileMaker.

This is something developers have been doing for years with the aid of plug-ins or by utilising the Web Viewer.  But now FileMaker 11 gives us the ability to produce basic charts, easily, within layout mode.

There are five different types of chart you can produce:

  • Bar
  • Horizontal Bar
  • Line
  • Area
  • Pie

Sample Bar Chart in FileMaker 11

All or these (apart from the Line chart) can be produced in 3D as well as 2D and FileMaker offers you a selection of colour palettes to choose from.

In the basic form you can plot data from either a delimited list of data or from all records in the current found set.  Beyond this you can also plot related data between tables.  You need to be careful when plotting related data as the chart will act exactly like a summary field when on a layout.  This means that the data it will represent has to follow those rules, such as be directly related between the table occurrence you are on and the data you are displaying, along with the fact that it will display in a sub-summary part in the same way.

This means that the chart are perfect for reporting purposes, but might not be as easily used to create a dashboard.  That requires a little more work and is something i will try and cover in a later blog.

So for now happy charting with FileMaker 11.

Paul de Hallé

Paul de Hallé

Paul de Hallé is the CEO and founder of Linear Blue, having set up the company in 1999 to focus on intuitive database solutions and web integration. Paul is a FileMaker Certified developer; and has also been a key player in the implementation of the FileMaker Certification program since it's inception with FileMaker 7. A regular guest speaker at FileMaker Business Alliance & Technet meetings in the UK and the FileMaker Developers Conference in the USA, along with contributing to various technical publications around the world.

More Posts - Website - LinkedIn

Leave a Reply