We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to create and update the chart with external data range using XlsIO?

Platform: WinForms |
Control: XlsIO |
Published Date: February 15, 2018 |
Last Revised Date: February 15, 2018

This article explains about creating and updating chart with external data range using XlsIO in C#/VB.NET

Is it possible to create or update chart with external data range?

No. It is not possible.

XlsIO does not have support for creating or updating data with external data range in XlsIO. However, we have provided a workaround to update the chart data from the external workbook.

To update the chart with external data range, you need to follow the below steps.

Steps to update chart with external data

  1. Open the input file which contains only and update the data manually.
  2. Then open both the Excel files containing data (DataWorkbook) and chart with data (ChartWorkbook) using XlsIO application.

 

  1. Get the data range from “DataWorkbook” and copy it to the “ChartWorkbook” in the chart’s data range.

 

  1. Save the Excel file contains chart. Now the data will be updated.
  2. Whenever the XlsIO application is executed, the chart data  range will be copied to “ChartWorkbook” and its chart will be updated.

 

To know more about charts in XlsIO, please refer the documentation.

Download input files

Download Complete Sample

The following C#/VB.NET complete code snippet shows how to update chart with external data range in XlsIO.

 

 

 

 

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon