Forum Discussion
Solved
Offset Formulas
I need to use an offset formula in the graph so when data is entered for Jan 22 through July 22 it will automatically update the graph. Any formula ideas? Series o
See How to Create a Dynamic Chart Range in Excel in particular the section "Using Excel formulas".
Please check Two top easiest ways to create a dynamic range in Excel chart (extendoffice.com) or google "excel dynamic charts" for other samples
- So Series 1 is column c and f, how does an offset formula work with 2 different ranges/
Column C will always have all values, so you should use the number of non-blank values in column F in the definition of the named ranges for both the x-values and the y-values.
- I am still having issues. Can I send you the sheet and see if you can figure out a good formula? I have many other graphs I need to apply this formula to. d
