IChart ChartArea Property |
<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>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart frame format</para><para>IChartFrameFormat frameFormat = chart.ChartArea;</para><para>//Set color</para><para>frameFormat.Fill.ForeColor = System.Drawing.Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Namespace: Spire.Xls.Core