There a several ways to address a column in Excel. You could use the offset function, BUT it is NOT SUPPORTED in Xcelsius 2008. You can also implement an offset counter which helps you addressing the correct column in your formulas.

Allright, nice workaround. But here is my best practice hint:
Excel operates in 2 modes. You can use characters for representing columns, which is the standard behaviour in Excel.
But you can also switch to R1C1-Mode, which means that your rows and your columns are addressed via figures. And this also works in Xcelsius and makes life much easier!
This is the default behaviour of column addressing in Excel:

Now, go to the options and switch on R1C1 mode.

Voila, here we go with a mode which enables us creating Dashboards much faster, without thinking of offsets.




