Change in graphs with Indirect?

  • Thread starter Thread starter Vokaj
  • Start date Start date
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.
 
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
(e-mail address removed)
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.
 
Back
Top