For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

CHARTING

SERIES Function

Represents a data series in the active chart. This function is used only in charts; you cannot use it in worksheets.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

You normally create a chart—with its SERIES functions—using an option in Excel's Insert, Chart group. But after you create the chart, you can manually edit the SERIES formula.

Syntax 1 For all charts except XY (Scatter) Plots

SERIES(name_ref, categories, values, plot_order)

  • name_ref  Optional. The name of the data series. It can be an external reference to a single cell, a name defined as a single cell, or text enclosed in quotation marks.
  • categories  Optional. An external reference to the cells that contain labels for the chart.
  • values  Required. An external reference to the cells that contain values.
  • plot_order  Required. An integer that specifies whether the series is plotted first, second, third, and so on in the chart. No two series can have the same number. As a general rule, series later in the plot order are plotted on top of series early in the plot order.

Syntax 2 For XY (Scatter) Plots

SERIES(name_ref, categories, values, plot_order)

  • name_ref  Optional. The name of the data series. It can be an external reference to a single cell, a name defined as a single cell, or text enclosed in quotation marks.
  • x_position  Optional. The X coordinate data for an XY (Scatter) plot.
  • y_position  Required. The Y coordinate data for an XY (Scatter) plot.
  • plot_order  Required. An integer that specifies whether the series is plotted first, second, third, and so on in the chart. No two series can have the same number. As a general rule, series later in the plot order are plotted on top of series early in the plot order.

Applies To

Excel 2003 and above

Remarks

SERIES references can have the following formats:
  • If the reference is to a cell address, the format is: sheet_name!cell_reference, like: Sheet1!$A$1:$A$3
  • If the reference is to a range name with a workbook scope, the format is: workbook_name!range_name, like: Book1.xlsx!NameOne
  • If the reference is to a range name with a worksheet scope, the format is: sheet_name!range_name, like: Sheet1!NameTwo

Examples

xxx

Other ExcelUser Information

  • xxx

OOther Help

  • Microsoft Help for the xxxx Function

 

Charley's SwipeFile charts


Free Excel Dashboards