I would like to create a simple bar chart representing only actual monthly
financial data. The idea is to dynamically select a range based on the
availability of consolidated number starting from January and expanding
progressively month after month.

I used to rely on the OFFSET function in Excel 2003, but it generates an
error when i try to manually type the formula in the Select Data wizard which
powers the charting engine.

Any suggestion on how I might solve this?

Thanks, Stefano