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.

The following example shows how to add a WordArt shape as a watermark for an existing chart’s plot area.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Open the existing excel file.
Workbook workbook = new Workbook(dataDir + "sample.xlsx");

// Get the chart in the first worksheet.
Aspose.Cells.Charts.Chart chart = workbook.Worksheets[0].Charts[0];

// Add a WordArt watermark (shape) to the chart's plot area.
Aspose.Cells.Drawing.Shape wordart = chart.Shapes.AddTextEffectInChart(MsoPresetTextEffect.TextEffect2,
"CONFIDENTIAL", "Arial Black", 66, false, false, 1200, 500, 2000, 3000);

// Get the shape's fill format.
FillFormat wordArtFormat = wordart.Fill;

// Set the transparency.
wordArtFormat.Transparency = 0.9;

// Get the line format.
LineFormat lineFormat = wordart.Line;

// Set Line format to invisible.
lineFormat.Weight = 0.0;

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