Excel

Ranking in SAP Dashboards

Learn how to create ranking in Excel with supported formulas in SAP Dashboards!

Interactive Candlestick Charting with Xcelsius

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 […]

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.