Data series define what data is displayed in the chart and how it is represented. Each data series connects to a data source (such as a database or XML file) and contains the settings that control the type of chart, style, labels, colors, and other display options.

Although most charts work with a single data series, you can add multiple data series to display different sets of data in the same chart.


Managing Data Series

To Add a New Data Series

  1. Go to the Data Series section in the Chart properties window.
  2. Click Add….
  3. Follow the wizard to define the properties of the data series.
  4. Click Finish to add the data series.

To Modify an Existing Data Series

  • Select the desired data series from the list and click Edit….

To Remove a Data Series

  • Select the data series and click Remove.

To Duplicate a Data Series

  • Select the data series and click Duplicate to create an exact copy.

To Adjust the Display Order

  • Use Move Up or Move Down to change the sequence of data series.
  • Note: The sequence determines how data series appear in the chart.

Properties Overview

Property SectionDescription
Chart TypeDefines the type of chart (2D or 3D) to display your data (e.g., bar, line, pie).
Data ProviderConnects the data series to an external data source for real-time data.
OptionsVarious settings related to the behavior and display options of the data series.
StyleControls the appearance, such as line width, bar spacing, or marker style.
LabelsAllows adding data labels to your series for better visualization and explanation.
ColorsSets the colors for elements like bars, lines, or segments within the data series.

Key Notes

  • You can mix different chart types (e.g., bars and lines) in the same chart by adding multiple data series.
  • Managing multiple data series allows creating complex and dynamic visualizations from various data sets.
  • Adjusting the order of data series impacts how they are layered or stacked in the chart.