EasyXLS

Chart inside a worksheet

Concept

EasyXLS™ library allows you to create Excel charts that can be positioned inside a worksheet. A chart can have two positions, as a distinct sheet or as an object in a worksheet. This chapter explains the second situation.

The Excel chart that is an object inside a worksheet has the position relative to sheet cells and the width and height of the Excel chart is specified in pixels.

EasyXLS also allows you to read Excel files that contain charts and extract chart information.

Concept in action

The below example shows how to export the chart to Excel and how the chart is placed inside a worksheet.

Source code sample

C#.NET
VB.NET
C++.NET
J#.NET
Java
PHP
ASP
C++
VB6
VBS
Coldfusion

The screen shot provides an example of an exported column chart placed inside a worksheet.

Exported Excel chart inside a sheet

Chart type

EasyXLS™ library provides a large number of chart types, such as column chart, line chart, bar chart, pie chart, scatter chart, area chart, doughnut chart, radar chart, surface chart, bubble chart, stock chart, cylinder chart, cone chart and pyramid chart.

Chart data source

A chart data source is composed of two sections:
   - Category axis labels (X axis)
   - Series (Y axis)

As presented in the above code sample, ExcelChart.easy_setCategoryXAxisLabels method is used for setting the labels on the category X axis. The series for Y axis values are added using ExcelChart.easy_addSeries method.

Formatting chart

EasyXLS lets you format the chart elements such as chart area, plot area, series, category X axis, value Y axis, gridlines, data table, legend, titles and 3D rotation.

Getting started with EasyXLS Excel library

To download the trial version of EasyXLS Excel Library, press the below button:

Download EasyXLS™ Excel Library for .NET and Java

If you already own a license key, you may login and download EasyXLS from your account.


 

Available for: Professional, Excel Writer, Excel Reader
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files
Java Excel Reader
Java version to read and import Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT