MicroCharts for Excel
MicroCharts enhances your Excel chart library with sparklines, bullet graphs and other in-cell charts. Charts are created from MicroCharts fonts including bars, line segments and pies. A chart is represented as text that is formatted with the MicroCharts fonts. Dynamic chart formulas update your charts when a dependent cell value changes.
Simply use the MicroCharts formulas like normal Excel formulas:
For richer formatting, use colored MicroCharts. The formatting parameters are
set with the MicroCharts user interface. Just double-click your formula to open
the formatting interface:
MicroCharts formulas can take advantage of Excel's rich set of financial and statistical functions. Use the PERCENTILE() formula to calculate the 10% and 90% limits of the normal band, a range that indicates the "normal" range of values:
=ColoredSparkLine(...,PERCENTILE(B5:M5,10%),PERCENTILE(B5:M5,90%))
If you can format a cell, you can format MicroCharts. You can utilize all the rich Excel capabilities for MicroCharts that you would for normal text!:
- Text alignment
- Text orientation
- Font size
- Conditional formatting
- Automatic alignment when the row height changes