Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Collapse]Spreadsheet
   [Expand]Product Information
   [Collapse]Concepts
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Collapse]Charting
      Charting Overview
      Chart Elements
      Creating a Chart
      Changing a Chart Type
      Applying a Predefined Chart Layout and Style
      Modifying a Chart Manually
     Printing
    [Expand]Mail Merge
     Protection
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Modifying a Chart Manually

After you create a chart, you can choose whether to apply one of the predefined chart layouts or specify your own layout. The ASPxSpreadsheet provides the capability to add axis titles and chart titles, show the chart legend, display gridlines, and data labels, etc.

Click it to display the Chart Tools contextual tab to modify a chart.

Expanded Add a Chart Title

Add a title to your chart by clicking the Chart Title button in the Labels group on the Layout tab, and then selecting the chart title's position. For example, click the Above Chart button to display the title at the top of the chart.

The image below illustrates the result.

Right-click the chart and select the Change Chart Title... item in the context menu to change the default text in the title. Specify a new chart title in the invoked Change Chart Title dialog box.

Expanded Add Axis Titles

Display horizontal and vertical axis titles by clicking the Axis Titles button in the Labels group on the Layout tab and doing the following:

  • Horizontal axis title: Select the Primary Horizontal Axis Title item, and then click the Title Below Axis button.

  • Vertical axis title: Select the Primary Vertical Axis Title item and then select the type of axis title (rotated, vertical or horizontal).

Right-click the chart and select the Change Horizontal Axis Title... or Change Vertical Axis Title... item in the context menu to change the default text in the axis title. Type a new title in the invoked dialog box.

Expanded Add a Chart Legend

Add a legend to the chart by clicking the Legend button in the Labels group on the Layout tab, and then selecting the legend's position.

For example, click the Show Legend at the Top button to display the legend above the plot area.

Expanded Display Data Labels

Display data values on the chart by clicking the Data Labels button in the Labels group on the Layout tab, and then selecting the data labels's position.

Expanded Add Gridlines

Display chart gridlines by clicking the Gridlines button in the Axes group on the Layout tab and doing one of the following:

  • Horizontal gridlines: Select the Primary Horizontal Gridlines item, and then select the type of gridlines.

  • Vertical gridlines: Select the Primary Vertical Gridlines item, and then select the type of gridlines.

A chart with horizontal and vertical gridlines is shown below.

How would you rate this topic?​​​​​​​