int main() {
lxw_workbook *workbook = new_workbook("test_chart_format24.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* For testing, copy the randomly generated axis ids in the target file. */
chart->axis_id_1 = 115374720;
chart->axis_id_2 = 115389568;
uint8_t data[5][3] = {
{1, 2, 3},
{2, 4, 6},
{3, 6, 9},
{4, 8, 12},
{5, 10, 15}
};
int row, col;
for (row = 0; row < 5; row++)
for (col = 0; col < 3; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart,
"=Sheet1!$A$1:$A$5",
"=Sheet1!$B$1:$B$5"
);
chart_add_series(chart,
"=Sheet1!$A$1:$A$5",
"=Sheet1!$C$1:$C$5"
);
lxw_chart_fill fill1 = {.color = LXW_COLOR_YELLOW, .transparency = 75};
lxw_chart_fill fill2 = {.color = LXW_COLOR_RED, .transparency = 25};
chart_chartarea_set_fill(chart, &fill1);
chart_plotarea_set_fill(chart, &fill2);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
int main() {
lxw_workbook *workbook = new_workbook("test_chart_chartarea05.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart = workbook_add_chart(workbook, LXW_CHART_PIE);
uint8_t data[3][2] = {
{2, 60},
{4, 30},
{6, 10},
};
int row, col;
for (row = 0; row < 3; row++)
for (col = 0; col < 2; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
chart_add_series(chart,
"=Sheet1!$A$1:$A$3",
"=Sheet1!$B$1:$B$3"
);
lxw_chart_line line1 = {.dash_type = LXW_CHART_LINE_DASH_LONG_DASH, .color = 0xFFFF00};
lxw_chart_line line2 = {.dash_type = LXW_CHART_LINE_DASH_DASH_DOT};
lxw_chart_fill fill1 = {.color = 0x92D050};
lxw_chart_fill fill2 = {.color = 0xFFC000};
chart_chartarea_set_line(chart, &line1);
chart_chartarea_set_fill(chart, &fill1);
/* This should be ignored for a pie chart. */
chart_plotarea_set_line(chart, &line2);
chart_plotarea_set_fill(chart, &fill2);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
