Skip to main content Skip to footer

Create Advanced Excel Charts in .NET and Java XLSX Spreadsheets

  • Access and customize data series, labels, value axis, and data points
  • Add a data series to an Excel chart
  • Customize Excel chart titles and legends using Java or .NET
  • Use chart templates to generate reports from a data source
Download Free Trial (V 7.1.3)

Latest Release Info

See what's new in Document Solutions for Excel v7.1

Overview

An Excel spreadsheet API library is a programming interface that allows developers to programmatically create and manipulate Excel documents at scale. Document Solutions for Excel (DsExcel) .NET and Java editions,  is a solution that allows developers to import/export, create reports & templates, and deploy spreadsheets across desktop applications.

Benefits of Advanced Charts in .NET and Java Excel APIs

Visualize Data 

Utilizing charts to visualize data will help highlight outlier values and graphically demonstrate trends, making this approach much easier than using plain tabular data.

Automate Excel Chart Creation

Advanced chart API interfaces enable the complete automation of chart creation using template spreadsheet processing.

Integrate Charts In Reports

Create advanced Excel spreadsheet reports by combining charts with calculations, conditional formatting, images, shapes, sparklines, tables, spreadsheet template cells, and chart series.

Analyze Trends and Patterns

Add trendlines, calculated series, and series colors to your charts to show KPI results, projected sales, seasonal trends, and more.

Customize Excel Charts

Make your charts more effective by customizing chart area, axes, data points, data labels, error bars, legend, lines, markers, plot area, series, and more.

Monthly Business Budget Data Visualization .NET Excel Charts

Monthly Business Budget

Visually compare and illustrate estimated versus actual income and expenses by creating a sample budget chart.

Learn More (.NET) Learn More (Java)
Cost Analysis Pareto Advanced Chart .NET Excel Charts

Cost Analysis Pareto

Design a cost analysis Pareto sample that shows relative costs as a fraction of the total, ranging from most significant to least significant in a bar series. This also illustrates the cumulative percentage in a line series to show a Pareto curve.

Learn More (.NET) Learn More (Java)
Data Visualization Personal Net Worth .NET Excel Charts

Personal Net Worth

Visualize data and highlight assets, debts, and computed net worth in a pie chart with percentages for each comparison.

Learn More (.NET) Learn More (Java)
Blood Pressure Tracker Advanced Chart Type .NET/Java Excel

Wellness Tracker

Create a Blood Pressure Tracker with the advanced chart types offered by .NET or Java Excel APIs.

Learn More (.NET) Learn More (Java)
Blood Sugar Tracker Advanced .NET and Java Excel Chart Type

Health Tracker

Create a sample chart to track health-related changes by using a line chart with a series that shows the calculated running average.

Learn More (.NET) Learn More (Java)

Advanced Chart Features in .NET and Java Excel APIs

Chart Types

Create every Excel chart type, including

Learn More .NET Learn More Java

Excel 2016 Chart Types

Create Excel 2016 chart types, such as:

Learn More .NET Learn More Java

3D Format Chart

Configure 3D formatting and customize the axis rotation, angles, and styles for the following elements:

Learn More .NET Learn More Java

Chart Area

Configure the chart area and customize the background behind the plot area:

 

 

Learn More .NET Learn More Java

Chart Axis

Configure chart axes and customize the following elements:

Learn More .NET Learn More Java

Chart Data Labels

Configure chart data labels and customize elements, such as:

 

Learn More .NET Learn More Java

Chart Template

Generate charts from chart templates by binding the chart data to a data source. Chart templates include

  • Axis Labels
  • Series Name and Values
  • Titles

Learn More .NET Learn More Java

Chart Data Points

Configure chart data points and customize elements like:

  • Negative Point Style (.NET) (Java)
  • Secondary section of Pie-of-Pie Chart (.NET) (Java)


Learn More .NET Learn More Java

Chart Error Bars

Configure chart error bars and customize elements, such as:

  • Error Bar Including Type and End Cap (.NET) (Java)
  • Error Bar X and Y direction
    (.NET) (Java)
  • And many more! (.NET) (Java)
Learn More .NET Learn More Java

Chart Legend

Configure the chart legend and customize elements, including:

  • Chart Legend Font Style 
    (.NET) (Java)
  • Chart Legend Position and Layout
    (.NET) (Java)
Learn More .NET Learn More Java

Chart Markers

Configure chart markers and customize the following elements:

Learn More .NET Learn More Java

Chart Plot Area

Configure the chart plot area and customize elements, such as:

Learn More .NET Learn More Java

Chart Series

Configure the chart series and customize elements, including:

Learn More .NET Learn More Java

Chart Shapes

Configure chart shapes and insert elements in charts like:

Learn More .NET Learn More Java

Chart Title

Configure the chart title and customize elements, such as:

Learn More .NET Learn More Java

Document Solutions Data Viewer

Check out the new Document Solutions Data Viewer (DsDataViewer) to view multiple data documents on the web. Take advantage of the seamless API to embed the JavaScript data viewer in cross-platform applications.

Learn More Try the Demos

Explore the Advanced Features of Spreadsheet API

Each main feature demo link listed below contains several demos that show how to use a particular feature. Click the button below to see the demos.

The demo includes a tutorial with step-by-step instructions on using Document Solutions for Excel to code spreadsheets. It also showcases numerous API features and includes code samples you can download and apply now.

Launch The Full Demo

Trusted by the World's Leading Companies

"The speed to build what we needed and the level of ease of use of controls are why we chose GrapeCity [now known as MESCIUS]. It was a perfect fit."

Spiro Skias - CGI