Category Archives: Design
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
Color Palet
UPDATE: I have updated this post finally and translated the components to English. In one of the session during the SAPInsider Xcelsius Bootcamp a attendant asked something about themes and templates. This made me update this page and clarify it … Continue reading
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
Drill in chart to different Tab
If you want to give your users the choice of clicking on a chart (e.g. clicking on the chart title) and then going to a specific tab where the KPI is displayed in more detail, you can use the property … Continue reading
Possible Waterfall charts in Xcelsius
In Xcelsius a waterfall chart is not default available in the versions up to SP4 (from SP4 onwards it is available), however with a little imagination you can create one from a stacked bar chart. Below I have published 4 … Continue reading
Reset a selector like combo box or radio button
1. Bind labels of the selector (eg. B2:B5) 2. Set Insertion type and destination (eg. C2) 3. Set the selected item type on Dynamic on the behaviour tab of the selector 4. Bind the item to a cell (eg F2) … Continue reading
