Forum Discussion
Adding Two Ranges for a Single Bar in a Chart
Whilst a Series definition might not accept an array formula, it will accept a defined name (sheet local names are useful because the name must be fully qualified by its parent sheet or book, and users tend to create shorter names on sheet tabs than for file names). The Name then contains the formula.
Note1: The concept of a named range is only a special case of the named formula in which the name happens to resolve to a sheet reference.
Note2: In extreme cases, complex charts can be created with no numbers coming from worksheets.
Whilst a Series definition might not accept an array formula, it will accept a defined name (sheet local names are useful because the name must be fully qualified by its parent sheet or book, and users tend to create shorter names on sheet tabs than for file names). The Name then contains the formula.
Note1: The concept of a named range is only a special case of the named formula in which the name happens to resolve to a sheet reference.
Note2: In extreme cases, complex charts can be created with no numbers coming from worksheets.