Perhaps you could show us what you typed.

An alternative to using a dynamic range is to make the data an Excel List
(have a look in Help). Data plotted from a List is automatically updated
when the list is added to or otherwise changed.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"smaruzzi" wrote in message
...

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