Can I use an array formula as a series in an Excel chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IS is possible to use an arrange formula as a series when constructing an
Excel chart. For example, in the Chart Wizard, on the series tab, add a
series and enter an array formula in the values box?
 
mrice256 said:
IS is possible to use an arrange formula as a series when constructing an
Excel chart. For example, in the Chart Wizard, on the series tab, add a
series and enter an array formula in the values box?
Click to expand...

No. However, you can get the same effect by using an array formula as a
named range, then using the named range as a series in the chart. This
is an annoying and awkward intermediate step, but it gets you everything
you want.

Many Excel chart experts use this technique to create charts that update
themselves as new data is manually added to the bottom of a range, or to
create charts that can be zoomed and panned using controls.
 
Back
Top