perspective property
int
get
perspective
Get the perspective for the 3D chart view (0 to 100).
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.perspective = 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 perspective {
return _perspective;
}
set
perspective
(int value)
set the persepective of 3D chart
Implementation
set perspective(int value) {
if (value < 0 || value > 100) {
throw Exception('elevation');
}
_perspective = value;
}