JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'), { sheetCount: 2 });
// ── 시트 1: 월별 수익률 추이 꺾은선 차트 ──
const sheet1 = spread.getSheet(0);
sheet1.name('수익률추이');
sheet1.suspendPaint();
const months = ['1월','2월','3월','4월','5월','6월','7월','8월','9월','10월','11월','12월'];
const portRet = [2.1, -1.3, 3.8, 1.2, -0.8, 4.5, 2.9, -2.1, 5.3, 1.8, 3.1, 2.7];
const benchRet = [1.5, -0.8, 2.9, 0.7, -1.2, 3.1, 1.9, -1.5, 3.8, 1.1, 2.4, 1.9];
sheet1.setValue(0, 0, '월');
sheet1.setValue(0, 1, '포트폴리오(%)');
sheet1.setValue(0, 2, '벤치마크(%)');
months.forEach((m, i) => {
sheet1.setValue(i + 1, 0, m);
sheet1.setValue(i + 1, 1, portRet[i]);
sheet1.setValue(i + 1, 2, benchRet[i]);
});
const lineChart = sheet1.charts.add(
'ReturnTrend',
GC.Spread.Sheets.Charts.ChartType.lineMarkers,
0, 0, 660, 490,
'A1:C13'
);
const lt = lineChart.title();
lt.text = '월별 수익률 추이 (포트폴리오 vs 벤치마크)';
lt.fontSize = 13;
lineChart.title(lt);
const s0 = lineChart.series().get(0);
s0.backColor = '#1565C0';
lineChart.series().set(0, s0);
const s1 = lineChart.series().get(1);
s1.backColor = '#EF5350';
lineChart.series().set(1, s1);
lineChart.legend({ position: GC.Spread.Sheets.Charts.LegendPosition.bottom });
sheet1.resumePaint();
// ── 시트 2: 자산 배분 도넛 차트 ──
const sheet2 = spread.getSheet(1);
sheet2.name('자산배분');
sheet2.suspendPaint();
const assets = [['국내주식', 45], ['해외주식', 25], ['채권', 15], ['대체투자', 10], ['현금', 5]];
sheet2.setValue(0, 0, '자산군');
sheet2.setValue(0, 1, '비중(%)');
assets.forEach(([name, pct], i) => {
sheet2.setValue(i + 1, 0, name);
sheet2.setValue(i + 1, 1, pct);
});
const donut = sheet2.charts.add(
'AssetAlloc',
GC.Spread.Sheets.Charts.ChartType.doughnut,
0, 0, 520, 460,
'A1:B6'
);
const dt = donut.title();
dt.text = '자산 배분 현황';
dt.fontSize = 14;
donut.title(dt);
donut.legend({ position: GC.Spread.Sheets.Charts.LegendPosition.right });
const dl = donut.dataLabels();
dl.showPercentage = true;
dl.showCategoryName = true;
dl.showValue = false;
donut.dataLabels(dl);
sheet2.resumePaint();
spread.setActiveSheetIndex(0);