Change in graphs with Indirect?

V

Vokaj

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.
 
D

Don Guillett

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
[email protected]
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.
 
Top