int main() {
lxw_workbook *workbook = new_workbook("test_chart_pattern03.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 = 110902272;
chart->axis_id_2 = 110756608;
uint8_t data[3][8] = {
{2, 2, 2, 2, 2, 2, 2, 2},
{2, 2, 2, 2, 2, 2, 2, 2},
{2, 2, 2, 2, 2, 2, 2, 2}
};
int row, col;
for (row = 0; row < 3; row++)
for (col = 0; col < 8; col++)
worksheet_write_number(worksheet, row, col, data[row][col], NULL);
lxw_chart_series *series1 = chart_add_series(chart, NULL, "=Sheet1!$A$1:$A$3");
lxw_chart_series *series2 = chart_add_series(chart, NULL, "=Sheet1!$B$1:$B$3");
lxw_chart_series *series3 = chart_add_series(chart, NULL, "=Sheet1!$C$1:$C$3");
lxw_chart_series *series4 = chart_add_series(chart, NULL, "=Sheet1!$D$1:$D$3");
lxw_chart_series *series5 = chart_add_series(chart, NULL, "=Sheet1!$E$1:$E$3");
lxw_chart_series *series6 = chart_add_series(chart, NULL, "=Sheet1!$F$1:$F$3");
lxw_chart_series *series7 = chart_add_series(chart, NULL, "=Sheet1!$G$1:$G$3");
lxw_chart_series *series8 = chart_add_series(chart, NULL, "=Sheet1!$H$1:$H$3");
lxw_chart_pattern pattern1 = {.type = LXW_CHART_PATTERN_PERCENT_10,
.fg_color = 0xC00000,
.bg_color = 0xFFFFFF};
lxw_chart_pattern pattern2 = {.type = LXW_CHART_PATTERN_PERCENT_60,
.fg_color = 0xFF0000};
lxw_chart_pattern pattern3 = {.type = LXW_CHART_PATTERN_LIGHT_UPWARD_DIAGONAL,
.fg_color = 0xFFC000};
lxw_chart_pattern pattern4 = {.type = LXW_CHART_PATTERN_LIGHT_HORIZONTAL,
.fg_color = 0xFFFF00};
lxw_chart_pattern pattern5 = {.type = LXW_CHART_PATTERN_DASHED_UPWARD_DIAGONAL,
.fg_color = 0x92D050};
lxw_chart_pattern pattern6 = {.type = LXW_CHART_PATTERN_WAVE,
.fg_color = 0x00B050};
lxw_chart_pattern pattern7 = {.type = LXW_CHART_PATTERN_DOTTED_GRID,
.fg_color = 0x00B0F0};
lxw_chart_pattern pattern8 = {.type = LXW_CHART_PATTERN_LARGE_GRID,
.fg_color = 0x0070C0};
chart_series_set_pattern(series1, &pattern1);
chart_series_set_pattern(series2, &pattern2);
chart_series_set_pattern(series3, &pattern3);
chart_series_set_pattern(series4, &pattern4);
chart_series_set_pattern(series5, &pattern5);
chart_series_set_pattern(series6, &pattern6);
chart_series_set_pattern(series7, &pattern7);
chart_series_set_pattern(series8, &pattern8);
worksheet_insert_chart(worksheet, CELL("E9"), chart);
return workbook_close(workbook);
}
/* Create a worksheet with a chart. */
int main() {
lxw_workbook *workbook = new_workbook("chart_pattern.xlsx");
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
lxw_chart *chart;
/* Add a bold format to use to highlight the header cells. */
lxw_format *bold = workbook_add_format(workbook);
format_set_bold(bold);
/* Write some data for the chart. */
worksheet_write_string(worksheet, 0, 0, "Shingle", bold);
worksheet_write_number(worksheet, 1, 0, 105, NULL);
worksheet_write_number(worksheet, 2, 0, 150, NULL);
worksheet_write_number(worksheet, 3, 0, 130, NULL);
worksheet_write_number(worksheet, 4, 0, 90, NULL);
worksheet_write_string(worksheet, 0, 1, "Brick", bold);
worksheet_write_number(worksheet, 1, 1, 50, NULL);
worksheet_write_number(worksheet, 2, 1, 120, NULL);
worksheet_write_number(worksheet, 3, 1, 100, NULL);
worksheet_write_number(worksheet, 4, 1, 110, NULL);
/* Create a chart object. */
chart = workbook_add_chart(workbook, LXW_CHART_COLUMN);
/* Configure the chart. */
lxw_chart_series *series1 = chart_add_series(chart, NULL, "Sheet1!$A$2:$A$5");
lxw_chart_series *series2 = chart_add_series(chart, NULL, "Sheet1!$B$2:$B$5");
chart_series_set_name(series1, "=Sheet1!$A$1");
chart_series_set_name(series2, "=Sheet1!$B$1");
chart_title_set_name(chart, "Cladding types");
chart_axis_set_name(chart->x_axis, "Region");
chart_axis_set_name(chart->y_axis, "Number of houses");
/* Configure an add the chart series patterns. */
lxw_chart_pattern pattern1 = {.type = LXW_CHART_PATTERN_SHINGLE,
.fg_color = 0x804000,
.bg_color = 0XC68C53};
lxw_chart_pattern pattern2 = {.type = LXW_CHART_PATTERN_HORIZONTAL_BRICK,
.fg_color = 0XB30000,
.bg_color = 0XFF6666};
chart_series_set_pattern(series1, &pattern1);
chart_series_set_pattern(series2, &pattern2);
/* Configure and set the chart series borders. */
lxw_chart_line line1 = {.color = 0x804000};
lxw_chart_line line2 = {.color = 0xb30000};
chart_series_set_line(series1, &line1);
chart_series_set_line(series2, &line2);
/* Widen the gap between the series/categories. */
chart_set_series_gap(chart, 70);
/* Insert the chart into the worksheet. */
worksheet_insert_chart(worksheet, CELL("D2"), chart);
return workbook_close(workbook);
}
