Sparklines with FMP11 Charts – Updated

Reposted with updated file — Sparklines demo is more interactive, with informative dynamic tooltips.

Download link for the demo file: SavvyData_ChartFun.fp7.zip

Sparklines are “data-intense, design-simple, word-sized graphics,” as their inventor Edward Tufte describes them in his book Beautiful Evidence. Due to their form and format, sparklines are most appropriate on lists and subsummary reports, and are well suited to

Read More

Bar Charts on Steroids

The bullet graph is a horizontal bar chart on steroids. This device was invented in 2005 by Stephen Few of Perceptual Edge, as a response to dashboard widgets that take lots of screen space to provide one piece of information.

By contrast, the bullet graph can efficiently convey quantitative data such as goal & percent attainment, as well as qualitative measures such as how good or bad a score of “85” really is. The unusual aspect to this is

Read More

Chart Palettes Cheatsheet for FMP11

Last week FileMaker Inc. announced FileMaker Pro 11 — and most early reviewers agree the most exciting new capability is charting. In the weeks to come I’ll be digging in and providing demo files for some cool uses of this important new tool.

If you already chart in FusionCharts or xmChart or 360Works Charts or AnyChart or xmChart or Maani or Google API or SimpleChart or [your unnamed favorite here], you will still find the built-in chart tool easier to use than any of those. It is amazingly convenient. And did I mention easy? If you’re not a charting fan yet, then I’m sure you soon will be.

That said, this IS the first version with charting built-in, so it would be good to keep expectations modest.

For example, FileMaker Pro 11 Chart automatically assign colors to the Y-axis data series/elements from a choice of 20 palettes. Unlike the advanced third-party charting options, you cannot assign a specific color to a particular data point.

However there are ways to get around the default color choices

Read More