Site Menu

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.

Building true predictive dashboards with Excel has never been easier. You can build sophiticated predictive models with tools such as ModelRisk or Oracle Crystal Ball. Your forecasts are dynamically updated after each simulation to reflect probabilities of achieving goals using current historical data.

Adding the visual power of Microcharts for Excel is as easy as adding a formula and formating text.

Orient your Microcharts using simple font controls	Colour is simple	Setting orientation

Some predictive models require more features in their graphs, including baselines, averages, time periods and standard deviations. All of which can be configured in Microcharts using intuitive dialog boxes.

By combininjg MicroCharts with Excel's stats functions or powerful packages like Oracle Crystal Ball and Model Risk for that added statistical horsepower, you can incoporate probabilistic information into your models and predictive dashboards. Because MicroCharts is easy to use, you can build sophisticated visuals into any model in record time

MicroCharts Features by Edition

 Supported Reporting Services versions

• Microsoft SQL Server Reporting Services 2005
• Microsoft SQL Server Reporting Services 2008

Supported Data Sources

• Microsoft SQL Server 
• Microsoft Analysis Services,
• OLEDB, ODBC
• Sap BI NetWeaver
• Hyperion Essbase
• Oracle
• Teradata

Features

• Line, area, column, pie, win-lose, icon and bar charts
• Bullet graphs - an effective replacement for dashboard gauges.
• All properties support expressions
• Support for Actions
• Intuitive formatting interface

Build your predictive dashboard with Excel using tables, MicroCharts, bullet graphs, sparklines and Excel Charts and create a real multi-user predictive web application with the MicroCharts WebEdition. 

With BonaVista Web, you can easily share the interactive reports and dashboards that you have created in BonaVista Dimensions or BonaVista MicroCharts with a large group of users. Sophisticated role-based access rights ensure that only authorized users can access and view sensitive information.

Once you have created you dashboards you can easily publish them to the Web with a click of the mouse. Users can then flexibly view their data from multiple angles or levels of detail. Role-based security options ensure that only authorized users can access sensitive data. The possibilities are endless.

Call us today for more information or to schedule a live-demo.

Download Brochure 

Sharing Excel Dashboards using Microcharts WebEdition

Supported Browsers: Internet Explorer, Firefox, Safari, Chrome.

Worksheets that are published from Excel to the WebEdition encompass the full scope and fidelity and maintain the same Excel worksheet and chart formatting.

Microcharts WebEdition Features

• Share interactive workbooks created with BonaVista Dimensions or BonaVista MicroCharts
• Fast and reliable Excel reporting in the web
• Supports 331 Excel functions and 7 Cube functions
• Support for Excel Charts and MicroCharts
• Scheduler for cube extract, transfer, and load
• User management with role based security

Chart Tamer aligns Excel’s charts with the best practices of data visualization. It tames Excel’s charts, which seem to exhibit Microsoft’s belief that “more is better”, by bringing them into line with the data presentation philosophy that “simple is better.” We don’t need more choices—we need a few good choices that really work.

Chart Tamer improves the charts that we produce with Excel in the following ways:

• Chart Tamer limits the list of available charts to the few that are most useful, thereby reducing the complexity of choosing an appropriate chart
• Chart Tamer provides a simple new interface for selecting an appropriate chart, which guides us to the right selection when help is needed without bogging us down when it’s not
• Chart Tamer adds three useful charts that aren’t currently available in Excel: dot plots, strip plots, and box plots
• Chart Tamer revises the formatting defaults of Excel’s charts so that no extra work is necessary to create charts that work effectively
• Chart Tamer provides colors for use in charts and elsewhere that were designed to work especially for data presentation
• Chart Tamer allows us to quickly and easily improve existing charts

For more information on enterprise and site licences call us today at 1-888-879-8440 or connect right now using the link above.