ExcelUser logo Free guides and templates
NOTICE. While work is in progress, much of this topic is incomplete. You can get more information here. Thanks for your patience.--Charley Kyd
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.


Charley Kyd is a Microsoft Excel MVP by Charley Kyd, MBA
Microsoft Excel MVP
The Father of Spreadsheet Dashboards

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

 

Dashboard Reporting With Excel


IncSight DB Excel Dashboards


Charley's SwipeFile charts