rotation property
int
get
rotation
sets the rotation of the 3D chart view (the rotation of the plot area around the z-axis, in degrees)-(0 to 360 degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts. The following code illustrates how to set
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.rotation = 20;
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 rotation {
return _rotation;
}
set
rotation
(int value)
Set the rotation of 3D view of chart.
Implementation
set rotation(int value) {
if (value < 0 || value > 360) {
throw Exception('rotation');
}
_rotation = value;
_isDefaultRotation = false;
}