Label Based Menu Interaction Options

In this post we will review interaction options of the Label Based Menu component.

One of the nice features under the interaction options of the label based menu component is the “Expand On” feature. This turns the menu into a condensed button which when clicked or mouse over expands a list or menu similar to a web based fly menu.

This feature is great for gaining a little extra canvas space for the more important components such as the chart or indicators on the dashboard.

How to achieve:

1. On the behavior tab of the label based menu component uncheck “Always Expanded”

2. Choose whether or not you want to expand on mouse click or mouse over. I prefer mouse over.

3. Choose the direction you want to expand. For horizontal orientation you have the option to expand left or right. For vertical orientation you can choose from center down, left down, right down, center up, left up, or right up.

4. Open Animation gives an animated “Flash” feel when the menu expands.

There you have it. An easy way to gain some additional real estate on your canvas.

Please let me know if you have any questions and as always please feel free to download the source files.

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 cell in the Play Control component.

Continue reading →

Video: Sneak Peek “XWIS Anywhere”

Xcelsius and Web Intelligence on Samsung Galaxy Tab

Who said Xcelsius cannot render properly on Mobile devices? Here is a video from Antivia, demonstrating Xcelsius and Web Intelligence reports on an Android powered Samsung Galaxy Tablet.

xcelsius-android

Video after the jump

Continue reading →

Free Excel and Xcelsius Webinars from DataPig Technologies

If you just got started in Xcelsius or are an intermediate user, these recorded webinars will be of great help. Mike Alexander of DataPig technologies was kind enough to share these webinars on his website. You can watch them for free. Apart from the Xcelsius webinars, if you are interested, there is also a recorded webinar on 10 Must Have Excel VBA Skills.

Click on the image below to go to the free webinar page.

xcelsius webinars

How to create a Radar animation using Xcelsius?

In designing a UFO Tracking dashboard for the Reportapalooza guest challenge, I decided that I needed to create a radar simulation. The math to get the radar to spin past zero wasn’t overly hard, but really through me for a loop at first (no pun intended)!

How to Create:
1. Setup play selector data

Cell A1: 0
Cell A2: =If(A1=100, 0, A1+1)

Continue reading →