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".
16 Replies
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.
