Main Menu
Xcelsius Journal Home Page
Search
File Vault
Links
The XJ Forum
Xcelsius Consulting Services
Contact Us
Editors Desk
Help me
Login Form





Lost Password?
No account yet? Register
Syndicate
Magazine Menu
The Xcelsius Journal
Featured Article
here
Article 024 - Sneak Peek: Xcelsius 2008 Dashboard Best Practices
In recent months I've been hard at work on a new book called Xcelsius 2008 Dashboard Best Practices, to be published by Business Objects Press. I owe my readers a sneak peek of what's to come.    
Read More >>
Current articles
Article 024 - Sneak Peek: Xcelsius 2008 Dashboard Best Practices
Article 023 - Xcelsius 2008 Tree Maps and other features
Article 022 - Adding BubbleMaps to your Dashboard Repertoire
Article 021 - Building Variable Width Charts
Authors
Loren Abdulezer
Mike Alexander
Loren Abdulezer and Mike Alexander
>View All Authors
Latest News
Article 023 - Xcelsius 2008 Tree Maps and other features PDF Print E-mail
Written by Loren Abdulezer   
Article Index
Article 023 - Xcelsius 2008 Tree Maps and other features
Page 2
Page 3
Page 4

Xcelsius 2008 extends Crystal Xcelsius in what you can do and how you go about building dashboards and visualizations. This article previews with a couple of its new features. One of them relates to improved integration between Excel and Xcelsius. The other showcases the Tree Map component. 
 

 


 

Overview

A rather remarkable feature of Xcelsius is its ability to embed a spreadsheet within a dashboard, thereby endowing or really turbocharging dashboards with industrial strength spreadsheet capabilities.

 

The idea is at once simple; take a spreadsheet with data and formula, import it into the Xcelsius Designer environment keeping all its formulas intact. Drag and drop visual components onto a dashboard canvas and bind the attributes of these components to cells in the underlying spreadsheet. Then press an export button to produce a fully interactive dashboard in the file format of your choice, be it a PowerPoint slide, a Word document, a PDF file, or a Flash file for viewing over the web or from your browser. 

 

What's more, the visualizations made with Xcelsius keep the spreadsheet formulas live and intact. This is an absolutely wonderful metaphor for bringing data in rows and columns to interactive visualizations.

 

The critics would charge that the metaphor of importing spreadsheets to the dashboard environment doesn't go far enough. The critic are right.

Quotation The critics would charge that the metaphor of importing spreadsheets to the dashboard environment doesn't go far enough. The critic are right. Quotation
Crystal Xcelsius allows for the importing (and re-importing) of spreadsheets. While you could make changes to the underlyiing spreadsheet, you have to do it outside Xcelsius. Then you must re-import the spreadsheet. Should spreadsheet cells be repositioned by say, adding or deleting some rows or columns, the binding to the spreadsheet from the Xcelsius components may need to be remapped. This has surely caused grief and consternation to many a dashboard designer.

 

Wouldn't it be nice to not have to work with your Excel spreadsheets in a detached mode when building your Xcelsius dashboards? The good news is now you can! 

 



Last Updated ( Wednesday, 12 March 2008 )
 
< Prev   Next >

The Xcelsius Journal   © 2013 Evolving Technologies Corporation - All rights reserved.