package AsposeCellsExamples.Charts;

import com.aspose.cells.*;
import AsposeCellsExamples.Utils;

public class ModifyPieChart {

	public static void main(String[] args) throws Exception {

		// The path to the documents directory.
		String dataDir = Utils.getSharedDataDir(ModifyPieChart.class) + "Charts/";

		// Instantiating a Workbook object
		Workbook workbook = new Workbook(dataDir + "ModifyCharts.xlsx");

		// Obtaining the reference of the first worksheet
		WorksheetCollection worksheets = workbook.getWorksheets();
		Worksheet sheet = worksheets.get(1);

		// Load the chart from source worksheet
		Chart chart = sheet.getCharts().get(0);
		DataLabels datalabels = chart.getNSeries().get(0).getPoints().get(0).getDataLabels();
		datalabels.setText("aspose");

		// Saving the Excel file
		workbook.save(dataDir + "ModifyPieChart_out.xls");

		// Print message
		System.out.println("Pie chart is successfully modified.");


	}
}
