General Information
WinForms Controls
	Prerequisites
	What's Installed
	Build an Application
	Controls and Libraries
		Forms and User Controls
		Messages, Notifications and Dialogs
		Editors and Simple Controls
		Ribbon, Bars and Menu
		Application UI Manager
		Docking Library
		Data Grid
		Vertical Grid
		Property Grid
		Pivot Grid
		Tree List
		Chart Control
		Diagrams
		Gauges
		Map Control
		Scheduler
		Spreadsheet
			Product Information
			Product Structure
			Getting Started
			Spreadsheet Document
			Supported Formats
			Cell Basics
			Spreadsheet Formulas
			Defined Names
			Data Binding
			Data Validation
			Data Presentation
			Data Grouping
			Pivot Table Overview
			Charting Overview
				Chart Elements
				Creating and Modifying a Chart Programmatically
			Shapes
			Printing
			Events
			Mail Merge Overview
			Protection
			Find and Replace
			Visual Elements
			Services
			Shortcuts
			Examples
		Rich Text Editor
		Spell Checker
		Form Layout Managers
		Navigation Controls
		Printing-Exporting
		PDF Viewer
		Reporting
		Snap
		TreeMap Control
	Common Features
	Get More Help
	API Reference
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Office File API
Reporting
Report and Dashboard Server
Dashboard
eXpressApp Framework
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
Tools and Utilities
End-User Documentation

WinForms Controls > Controls and Libraries > Spreadsheet > Charting Overview > Creating and Modifying a Chart Programmatically

Creating and Modifying a Chart Programmatically

You can use the Spreadsheet Chart API to create charts and modify them in code.

The following table lists the most useful objects, properties and methods of the Spreadsheet Chart API with short descriptions.

Member	Description
Worksheet.Charts	Provides access to a collection of charts in a worksheet.
ChartType	Lists values used to specify the chart subtypes.
Chart	An embedded chart on a worksheet.
ChartObject.SelectData	Specifies a worksheet range containing chart data and creates series with automatically selected type.
ChartObject.ChangeType	Changes the type of the chart.
ChartObject.Series	Provides access to the collection of Series objects.
ChartObject.Views	Provides access to a collection of chart views used to plot data series of specific types.
ChartObject.Title	Gets the title of the chart.
ChartObject.Legend	Provides access to a chart legend.
Legend.CustomEntries	Provides access to a collection of modified legend entries.
ChartObject.PrimaryAxes	Provides access to a collection of primary axes.
Series.AxisGroup	Gets or sets the group type for the axes which are used to plot the series data.
ChartView.DataLabels	Provides access to options used to modify all data labels within a chart view.
Series.CustomDataLabels	Provides access to a collection of data labels customized for specific data points or for the entire series.
ChartOptions.Protection	Gets or sets the chart protection.
IWorkbook.ChartSheets	Provides access to a collection of chart sheets contained in a workbook.
ChartSheet	A separate sheet in a workbook that contains only a chart.
ChartSheet.Chart	Provides access to the chart on the current chart sheet.
ChartSheet.ActiveView	Provides access to an object that contains options to display and print a chart sheet.
ChartSheet.PrintOptions	Provides access to options that control how the chart sheet is printed.
ChartSheet.HeaderFooterOptions	Provides access to options which determine the chart sheet header and footer characteristics.
ChartSheet.Protect	Protects chart sheet elements to prevent them from being changed by the user.

Creating and Modifying a Chart Programmatically

See Also