| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing graph axes using named range
With a few adjustments that seems to do the trick thanks!
Is there a way of making the named ranges more dynamic? I know of the counta formula so it goes to the end of the data when you add more, the only problem for me being that my columns are filled with if formulas that are taken into account using the counta formula. Is there an alternative? Thanks, Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Automatically changing the range in a graph | Charts and Charting in Excel | |||
| Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Hybrid Mode
