depthPercent property

int get depthPercent

Returns the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

final Workbook workbook = Workbook();
final Worksheet sheet = workbook.worksheets[0];
sheet.getRangeByName('A11').text = 'Venue';
sheet.getRangeByName('A12').text = 'Seating & Decor';
sheet.getRangeByName('A13').text = 'Technical Team';
sheet.getRangeByName('A14').text = 'performers';
sheet.getRangeByName('A15').text = "performer's Transport";
sheet.getRangeByName('A16').text = "performer's stay";
sheet.getRangeByName('A17').text = 'Marketing';
sheet.getRangeByName('B11:B17').numberFormat = r'$#,##0_)';
sheet.getRangeByName('B11').number = 17500;
sheet.getRangeByName('B12').number = 1828;
sheet.getRangeByName('B13').number = 800;
sheet.getRangeByName('B14').number = 14000;
sheet.getRangeByName('B15').number = 2600;
sheet.getRangeByName('B16').number = 4464;
sheet.getRangeByName('B17').number = 2700;
final ChartCollection charts = ChartCollection(sheet);
final Chart chart = charts.add();
chart.chartType = ExcelChartType.line3D;
chart.dataRange = sheet.getRangeByName('A11:B17');
chart.isSeriesInRows = false;
chart.chartTitle = 'Line Chart 3D';
chart.depthPercent = 45;
chart.topRow = 8;
chart.leftColumn = 1;
chart.bottomRow = 23;
chart.rightColumn = 8;
sheet.charts = charts;
final List<int> bytes = workbook.saveAsStream();
saveAsExcel(bytes, 'FLUT_6975_3D_LineChart.xlsx');

Implementation

int get depthPercent {
  return _depthPercent;
}

set depthPercent (int value)

set the elevation of 3D chart

Implementation

set depthPercent(int value) {
  if (value < -90 || value > 90) {
    throw Exception('elevation');
  }
  _depthPercent = value;
}