How to set shadows for plot area or axis in chart using XlsIO?

Platform: WinForms |

Control: XlsIO |

Published Date: February 28, 2018 |

Last Revised Date: March 1, 2018

This article explains how to set shadow to plot area in chart using XlsIO.

What is Plot Area?

The plot area in a chart or graph refers to the area of the chart that graphically displays the data being charted. The plot area of a 2-D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. Whereas the plot area of a 3-D chart contains all the above items along with walls, floor, axes, axis titles, and tick-mark labels in the chart.

$C:\Users\kondurukeerthi.kondu\AppData\Local\Microsoft\Windows\INetCache\Content.Word\Set_Shadow.png$

Shadow for plot area set using XlsIO

Code snippet to set shadow to plot area in chart using XlsIO

Steps to add shadow to plot area in chart

Initialize chart

Create a chart object by calling the worksheet.Charts.Add method and specify the chart type to ExcelChartType.Line enum value.

Assign data

Set a range of data from the worksheet to chart’s DataRange property. To plot the series values in column and categories in row, set chart’s IsSeriesInRows property to false.