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.