Sparklines

The largest collection of sparklines in the world: 18 types of word-sized charts for Excel!

Here is the complete list by categories:

  • Performance: Bullet chart & Reverse Bullet chart.
  • Evolution: Line, Area & Horizon.
  • Comparison: H-Bar chart, Barchart, V-Bar & Varichart.
  • Composition: Cascade chart / waterfall chart, Stacked, PieFlat, Pareto.
  • Distribution: BoxPlot, Stripes & Spread.
  • Correlation: Heatmap.
  • Scales.

This type of visualization is characterized by its small size, providing a real data density in each cell (far better than providing only one figure).

Even if Sparklines don't show details, they help you to drive by giving you the opportunity to visualize KPI's progress (long-term trend, or exceptions).
By showing acceleration insights or variations (more useful than some decimals), Sparklines enhance your decision making ability.

The term Sparkline was first proposed by Edward Tufte for "data-intense, design-simple, word-sized graphics".
Sparklines are also called in-cells graphics, mini-charts or micro-charts.

 

Dashboard with Sparklines.

 

How to create Sparklines with BeGraphic?

Click on the "Spaklines pro" button in the BeGraphic ribbon.


  • Your macro security settings need to be enabled.
  • To know how to change it, go to the forum to read the 'How-to' documentation here.

 

Click on "Insert SFE" and select the type that you are interested in (e.g.: bullet chart, line chart, cascade, pareto, heatmap...).

 

Set up the function window (e.g.: Points1, Points2, Minimum, Maximum...).

 

 

More explanation

  1. Tips and tricks about Sparklines are on the dedicated forum page here.
  2. The PDF manual is downloadable here.
  3. Information about Sparklines Pro here.

 

 

Why choosing BeGraphic?

Other tools allow you to create Sparklines, such as: Excel 2010, Qlikview, Cognos, Business Objects, Xcelsius, Oracle Obiee, Bissantz Sparkmaker, Bonavista Microcharts, Infor Application Studio, SAS, Jasper Reports, Microstrategy, Tibco Spotfire, Tableau Software, Arcplan Dynasight or Information Builder Webfocus.

However, BeGraphic is the only software that offers you:

  • The largest range of Sparklines (18 types of in-cell charts).
  • Available in Microsoft Office (Excel & PowerPoint).
  • At zero cost (Sparklines for Excel is a free product).

 

Download the Lite Version of BeGraphic now (FREE).

 

 

 

 

 

examples of free sparklines in excel (intense, simple, wordlike graphics): free sparklines for excel 2010 but also excel 2007, sparkmaker, mini-charts, miniatured charts, free microcharts, word-sized charts, Beautiful Evidence by Edward Tufte, spark line mini chart, in-cell charts, dynamic sparklines, free sparklines for powerpoint, free small charts, gratuitous tiny graphics and tinygraphs, free ultra dense charts in powerpoint, very small charts in excel, microscopic charts for ppt, smallest charts in presentation, mini charts for dashboard, nanocharts, little charts in Excel, mini column graphs, area graphs, trends & exceptions graphs, trend indicators, 18 types of charts: bullet chart, line chart, area chart, horizon chart, hbar chart, barchart, Vbar chart, Varichart, cascade, stacked chart, Pieflat, Pareto chart, BoxPlot, Stripes chart, Spreadchart, Heatmap and scales. Data-intense management information system, business intelligence dashboards, management dashboard, management cockpit, dynamic dashboards, sparklines types, largest collection of sparklines in the world, sparklines maker, sparkline functions, Microsoft Office add-in. Excel chart library with sparklines, Excel dashboard reporting, create your own sparklines in Excel, user-defined functions, free dashboard tool, concise data visualization, Excel 2010, largest range of sparklines types, KPI icons, MicroBars, MicroColumns. reduce each chart to the size of a word, remove all unnecessary legends and grids, mini-graphs and all on a single page, considers historic changes for each value (e.g. trends or cyclical ups-and-downs) and compares these, generate automatically updated sparklines in Excel reports, BeGraphic is a simple add-on to Microsoft Office and provides all sparkline technology required for business purposes, our sparklines in Excel spreadsheet offers bars, lines, whiskers (win/loss-indicators) and pie charts as sparkline variants, create sparklines manually and insert them directly into Excel cells or even into Microsoft Word documents and PowerPoint slides, sparkline concept has been promoted by Edward Tufte (Professor Emeritus at Yale University, www.tufte.com), the renowned expert for information design. He states that at the heart of the concept are "intense, simple, word-sized graphics": A sparkline depicts data in miniaturized graphs and contributes context information to interpret indicators. Besides using sparklines to enhance traditional paper-based reports which are generated in Microsoft Office to use electronic displays for consuming information. Sparklines based on user-defined Excel functions are also perfectly suited for management reporting and analysis in such modern electronic management dashboards and cockpits, create richer, more concise reports and dashboards with more information per square inch. Using the latest techniques in dashboard reporting, BeGraphic helps you generate data-rich tables and graphs as small as the size of words. This clear presentation helps business professionals quickly zoom in on trends in their data and ultimately make better business decisions, gratis spark lines for Excel, gratuitous sparklines in spreadsheet, excel are free tiny graphs or micro charts, nano chart is a free sparkline in excel (bar, column, pie charts), powerpoint and free sparklines