| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change in graphs with Indirect?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change in graphs with Indirect?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINK GRAPHS | Charts and Charting in Excel | |||
| Change value in cell | Excel Discussion (Misc queries) | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
Linear Mode
