Pythonでもっと自由を

【Python×Excel】How to make the “Scatter”, “Bubble Chart” in openpyxl【Practice】

This article explains the procedure for creating "Scatter" and "Bubble Chart" with "openpyxl library" with illustrations and sample code. How to apply plot area formatting (markers/data labels/fill) is also discussed.

2022/04/30 09:02

【Python×Excel】How to make the “Bar Chart” in openpyxl and design recipe【Practice】

The procedure for inserting a "Bar (bar) graph" in the "openpyxl library," which manipulates Excel, will be illustrated with sample code. In addition, examples of applying bar formatting (fill and data labels) to plot areas will be explained in detail.

2022/04/20 07:23

【Python×Excel】How to make the “Line Chart” in openpyxl and design recipe【Practice】

The procedure for inserting a "line chart" in the "openpyxl library," which manipulates Excel, will be explained with illustrations and sample code. In addition, examples of applying "lines," "markers," and styles to plot areas will be introduced.

2022/04/15 12:00

【Python×Excel】How to draw a graph in openpyxl【Basic Rules】

This section provides illustrated instructions for inserting graphs into Excel with the "openpyxl library". The definition of the reference range of data and the elements (objects) that make up a graph, such as "title," "legend," "line," and "marker," are covered.

2022/04/03 08:58