Python第三方库之openpyxl(7)
2024-08-29 22:44:06
Python第三方库之openpyxl(7)
散点图
散点或xy图表类似于一些折线图。主要的区别在于,一个系列的值被绘制在另一个值上。当值未排序时,这是有用的。
from openpyxl import Workbook
from openpyxl.chart import (
ScatterChart,
Reference,
Series,
) wb = Workbook()
ws = wb.active rows = [
['Size', 'Batch 1', 'Batch 2'],
[2, 40, 30],
[3, 40, 25],
[4, 50, 30],
[5, 30, 25],
[6, 25, 35],
[7, 20, 40],
] for row in rows:
ws.append(row) chart = ScatterChart()
chart.title = "Scatter Chart"
chart.style = 13
chart.x_axis.title = 'Size'
chart.y_axis.title = 'Percentage' xvalues = Reference(ws, min_col=1, min_row=2, max_row=7)
for i in range(2, 4):
values = Reference(ws, min_col=i, min_row=1, max_row=7)
series = Series(values, xvalues, title_from_data=True)
chart.series.append(series) ws.add_chart(chart, "A10") wb.save("scatter.xlsx")
运行结果
最新文章
- Java代码规范
- 解决R速度太慢问题
- zw版【转发·台湾nvp系列Delphi例程】HALCON Component Histogram
- 【Unity Shaders】初探Surface Shader背后的机制
- CDH hadoop的安装
- Windows Server 2012远程刷新客户端组策略,IE代理设置
- HDU 4405-Aeroplane chess(概率dp)
- Composer使用笔记
- J-Link固件烧录以及使用J-Flash向arm硬件板下载固件程序
- RabbitMQ在windows系统安装部署文档
- [LeetCode] Score After Flipping Matrix 翻转矩阵后的分数
- yarn查询/cluster/nodes均返回localhost
- localhost和127.0.0.1及ip区别
- macOS Sierra WiFi connecting problem
- PyQt5信号、定时器及多线程
- Flash and Scalform CLIK
- Python中常见字符串去除空格的方法总结
- mingw 搭建Emscripten 环境
- 2017年最新cocoapods安装教程(解决淘宝镜像源无效以及其他源下载慢问题)
- No supported encrypter found. The cipher and / or key length are invalid.