Tag Archives: chart

Tableau: Relative Date Filter over year change

In case you want to compare years when filtering on last x weeks and have the year comparison over the year change (week 53 and week 1), you can’t use a relative date calculated field filter as this method transforms … Continue reading

Filed under Miscelleneaous, Tableau | Tagged , , , , | Leave a comment

Negative values and Treemap

The treemap component is able to handle negative colour intensities …. as long at least 1 intensity is positive. This means you need to add at least one row with an empty label field, 0 as value and 1% as … Continue reading

Filed under Components | 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

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

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