Why not just use a defined name range as the series? Why not post your
efforts along with a layout and exactly what you want.


--
Don Guillett
SalesAid Software

"Vokaj" wrote in message
oups.com...
Hello,

I am using an excel sheet to track the sales in my company but every
month I need to open the graphs and change the cells to cover the last
month.

I want to only change the number in a cell and make the graph shows the
period that I want.

I tried using INDIRECT formula but it doesn´t let me do it.

Any help?

Thanks.