Change Tick Label Direction with C++

Change Tick Label Direction

Aspose.Cells provides you with the ability to change the chart tick label direction by using the TickLabels.GetDirectionType() property. The TickLabels.GetDirectionType() property accepts the ChartTextDirectionType enumeration value. The ChartTextDirectionType enumeration provides the following members:

• Horizontal
• Vertical
• Rotate90
• Rotate270
• Stacked

The following image compares the source and output files:

Source file image

Output file image

The following code snippet changes the tick label direction from Rotate90 to Horizontal.

Sample Code

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

int main()
{
    Aspose::Cells::Startup();

    // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

    // Directory source and output paths
    U16String sourceDir(u"..\\Data\\01_SourceDirectory\\");
    U16String outDir(u"..\\Data\\02_OutputDirectory\\");

    // Create workbook and load the sample Excel file
    Workbook workbook(sourceDir + u"SampleChangeTickLabelDirection.xlsx");

    // Obtain the first worksheet
    Worksheet worksheet = workbook.GetWorksheets().Get(0);

    // Load the chart from the source worksheet
    Chart chart = worksheet.GetCharts().Get(0);

    // Set the category axis tick labels direction to Horizontal
    chart.GetCategoryAxis().GetTickLabels().SetDirectionType(ChartTextDirectionType::Horizontal);

    // Output the modified workbook to a new file
    workbook.Save(outDir + u"outputChangeChartDataLableDirection.xlsx");

    std::cout << "Chart tick label direction changed successfully!" << std::endl;

    Aspose::Cells::Cleanup();
}

The source and output files can be downloaded from the following links.

Source File

Output File