const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
// 데이터 구성
const headers = ['월', '매출(만원)', '전월비(%)'];
const rows = [
['1월', 3200, null],
['2월', 3580, 11.9],
['3월', 3920, 9.5],
['4월', 4150, 5.9],
['5월', 3870, -6.7],
['6월', 4420, 14.2],
];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#0D47A1').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 60 : 100);
});
rows.forEach((row, r) => row.forEach((v, c) => {
if (v !== null) sheet.setValue(r + 1, c, v);
}));
sheet.setRowHeight(0, 32);
// 기본 Bar 차트 — 매출 시리즈
const chart = sheet.charts.add(
'comboChart',
GC.Spread.Sheets.Charts.ChartType.columnClustered,
0, 130, 580, 330,
'A1:B7',
GC.Spread.Sheets.Charts.RowCol.columns
);
chart.title({ text: '월별 매출 및 전월 대비 성장률' });
// 성장률 시리즈 추가 — Line 타입 + 보조 Y축
const growthSeries = {
chartType: GC.Spread.Sheets.Charts.ChartType.lineMarkers,
name: '전월비(%)',
xValues: 'Sheet1!A2:A7',
yValues: 'Sheet1!C2:C7',
axisGroup: GC.Spread.Sheets.Charts.AxisGroup.secondary
};
chart.series().add(growthSeries);