Add WordArt Watermark to Chart

You can use WordArt to add special text effects to spreadsheets. For example, stretch a title, decorate text, make the text fit a preset shape, or apply the affected text to a chart’s plot area as a watermark. The WordArt becomes an object that you can move or position in your spreadsheets to add decoration.

The following example shows how to add a WordArt shape as a watermark for the chart plot area.

Adding WordArt Watermark to Chart

The following example shows how to add a WordArt shape as a watermark for an existing chart’s plot area. The example uses a template Excel file that already contains the chart.

Comparison pictures for before and after the code execution

The input file

The output file

Java code to add WordArt Watermark to charts

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(AddWordArtWatermarkToChart.class) + "articles/";
// Instantiate a new workbook, Open the existing excel file.

Workbook workbook = new Workbook(dataDir + "sample.xlsx");

// Get the chart in the first worksheet.
Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);

// Add a WordArt watermark (shape) to the chart's plot area.
Shape wordart = chart.getShapes().addTextEffectInChart(MsoPresetTextEffect.TEXT_EFFECT_1, "CONFIDENTIAL",
		"Arial Black", 66, false, false, 1200, 500, 2000, 3000);

// Get the shape's fill format.
FillFormat wordArtFormat = wordart.getFill();

// Set the transparency.
wordArtFormat.setTransparency(0.9);

// Get the line format.
LineFormat lineFormat = wordart.getLine();

// Set Line format to invisible.
lineFormat.setWeight(0.0);

// Save the excel file.
workbook.save(dataDir + "AWArtWToC_out.xlsx");