Category Archives: Components

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

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

Filed under Components, Design, Xcelsius | Tagged , , , | 22 Comments

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

Filed under Components, Design, Xcelsius | 2 Comments

Selectors: 6 steps to Multiple Selection

As I get more and more request for the multiple select file I have written out below the steps to take (thus I will not send the file anymore, you can follow the steps yourself ). Also I updated the … Continue reading

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

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

Filed under Components, Design, Xcelsius | Tagged , , , , , | 4 Comments

Change axes label color in chart

Use the custom format option in Excel if you want to dynamically change the vertical axes labels to a alert color. Eg. [Blue][>0]#,##0;-[Red]#,##0 will show positive numbers in blue and negative numbers in red.

Filed under Components, Design, Excel, Xcelsius | Tagged , , | 3 Comments