Click or drag to resize

IChart PlotVisibleOnly Property

True if only visible cells are plotted. False if both visible and hidden cells are plotted.
Examples
The following code illustrates how to set PlotVisibleOnly to "true" so that chart plots all the cells within the chart's DataRange:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10";
 worksheet.Range["B2"].Text = "20";
 worksheet.Range["C2"].Text = "30";</para><para>//Hide column and create chart</para><para>worksheet.Columns[2].ColumnWidth = 0;</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Plot visible only</para><para>chart.PlotVisibleOnly = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
bool PlotVisibleOnly { get; set; }

Property Value

Type: Boolean
See Also