Tag Archives: Excel

How to get a Sharepoint List in Xcelsius and publish outside Sharepoint

If eg. Treasury is maintaining a Tax Rate by country list in the Corporate Sharepoint directory, you can import that list into Xcelsius for use in your dashboard without setting up a portal provider as you do not want to … Continue reading

Filed under Connection | Tagged , , , | 4 Comments

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

Installation Fixpack 3.5 and Office2010

I tried to install fixpack 3.5 and got the error message that I need Office XP or a newer version. However I do have Office2010 installed. So I thought to do the same as in my previous post, I hacked … Continue reading

Filed under Excel, Install, Xcelsius | Tagged , , , , , | Comments Off

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

Excel file does not open in Windows Explorer

If you work with the Live Office Comptaibility enabled in Xcelsius, changes are that you cannot open an Excel file from the network anymore. However when strating Excel and then navigating to the file on the network in Excel itself, … Continue reading

Filed under Connection, Excel | Tagged , , , , | 2 Comments

Formula: Weeknum() in Excel 2003

In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now. Furthermore if you use the Dutch version of … Continue reading

Filed under Excel | Tagged , , | 1 Comment