Tag Archives: tricks

Do you know these tricks?

During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading

Filed under Components, Design, Excel | Tagged , , , , , | 1 Comment

Values send as text by BIWS connection

I have spend some frustating hours trying to figure out, why my number format did not work properly in my preview mode. Data was brought in the dashboard by BIWS connection. I thought it had to do with the locale, … Continue reading

Filed under Connection, Excel | Tagged , , , , | 1 Comment

Panel Set and embedded Xcelsius swf

As you may have noticed, the panel set does NOT support embedded swf created by Xcelsius. The common workaround is to use external URL link. However another workaround is to embed a JPG image (or swf not created by Xcelsius) … Continue reading

Filed under Components, Xcelsius | Tagged , , | 1 Comment

Xcelsius chart versus Excel chart

Now I always hate it when someone comes with an Excel chart that I have to duplicate. Excel is THE manupulation tool a user can have, thus ofcourse the chart capabilities are endless. And as Xcelsius is based on Excel, … Continue reading

Filed under Excel, Other, Xcelsius | Tagged , , , | 2 Comments

Tips & Tricks Xcelsius Short List

Customers ask me often to give them the list of the tips and tricks I mention during training. I thought to share it with you also. General Regional Settings client PC: Location set to UK and number format to English … Continue reading

Filed under Components, Connection, Design, Install, Other, Xcelsius | Tagged , , , , , | 3 Comments

Calender not showing default date selected

In reply to the request: “I need a way to have the Calendar component give the default date to be passed without actually showing the component’s selected date. Any ideas?” You can achieve this by using 2 calenders, 1 with … Continue reading

Filed under Components, Xcelsius | Tagged , , , | Comments Off