Do you need to display stock information in an interactive SAP BusinessObjects Dashboard model? This post shows how to do just that. With as little as two components – the Candlestick Chart and a List Box – you can create and deliver an hour-by-hour and interactive display of stock performance for a selected day. Download [...]
Excel
Adding Regression Trends to a Dashboard
Do you need to display the Linear Regression or Logorithmic Regression of data trends in an Xcelsius dashboard but don’t know how to write the required formulas? If so, you’ll be extremely pleased to know how easily these regression types can be created in Xcelsius. And all without having to figure out which formula to [...]
Christmas Lights with Xcelsius
This post shows how to create Christmas lights in Xcelsius by using just a couple components. The two components used in this example are the Push Button and Play Control component. Just five formulas were written in the spreadsheet to alternate the colors and create “blinking lights”. These formulas are all based on the Data [...]
Free Excel and Xcelsius Webinars from DataPig Technologies
Free recorded webinars from DataPig technologies.
How to implement an expiration date in an Xcelisus dashboard?
Here is an Xcelsius/Excel trick that allows you, the developer, to set a validity period on a dashboard. This is great for sharing demos or giving a potential client an evaluation period. 1. Setup your Excel file as follows
