How to set category axis

Possible Usage Scenarios

After you create a chart in a worksheet, then you can set category axis for it. In this article, we will show you how to set category axis for Excel chart, using Aspose.Cells with sample code.

The steps in sample code

1. Create a new workbook.

2. Create a new chart in the first worksheet.

3. Add some values to cells in the first worksheet.

4. Now you can set the category axis, there are two ways: using cell data, or using strings directly, both of which are shown in the sample code.

5. Set value axis, save the workbook to view the result.

The following sample code generates the output Excel file.

Sample Code

		//How to Set Category Axis

		//Your local test path
		String path = "";

		//Create a new workbook
		Workbook workbook = new Workbook();
		Worksheet worksheet = workbook.getWorksheets().get(0);
		worksheet.setName("CHART");

		// Add a chart to the worksheet
		int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 8, 0, 20, 10);
		Chart chart = worksheet.getCharts().get(chartIndex);

		//Add some values to cells
		worksheet.getCells().get("A1").putValue("Sales");
		worksheet.getCells().get("A2").putValue(100);
		worksheet.getCells().get("A3").putValue(150);
		worksheet.getCells().get("A4").putValue(130);
		worksheet.getCells().get("A5").putValue(160);
		worksheet.getCells().get("A6").putValue(150);
		worksheet.getCells().get("B1").putValue("Days");
		worksheet.getCells().get("B2").putValue(1);
		worksheet.getCells().get("B3").putValue(2);
		worksheet.getCells().get("B4").putValue(3);
		worksheet.getCells().get("B5").putValue(4);
		worksheet.getCells().get("B6").putValue(5);

		//Some values in string
		String Sales = "100,150,130,160,150";
		String Days = "1,2,3,4,5";

		//Set Category Axis Data with string
		chart.getNSeries().setCategoryData("{" + Days + "}");
		//Or you can set Category Axis Data with data in cells, try it!
		//chart.getNSeries().setCategoryData("B2:B6");

		//Add Series to the chart
		chart.getNSeries().add("Demand1", true);
		//Set value axis with string 
		chart.getNSeries().get(0).setValues("{" + Sales + "}");
		chart.getNSeries().add("Demand2", true);
		//Set value axis with data in cells
		chart.getNSeries().get(1).setValues("A2:A6");

		//Set some Category Axis properties
		chart.getCategoryAxis().getTickLabels().setRotationAngle(45);
		chart.getCategoryAxis().getTickLabels().getFont().setSize(8);   
		chart.getLegend().setPosition(LegendPositionType.BOTTOM);

		//Save the workbook to view the result file
		workbook.save(path + "Output.xlsx");