Forum Discussion

BSM2023's avatar
BSM2023
Copper Contributor
Jan 19, 2026

What is the SERIES function?

Identifying ranges for a graph the result that comes back is SERIES(Name, Range, Range,n). What is the additional parameter?

I can't find SERIES anywhere in Excel support.

1 Reply

  • The final parameter is simply a sequence number defining the order in which the series are stacked on the chart.  The user experience offered by the SERIES command is somewhat different from other functions because it is not processed by the Excel calc engine but, rather, by a distinct charting engine (this is my understanding, not official documentation I have at hand).

     

    Change the data series in a chart - Microsoft Support

Resources