Python中利用openpyxl对图表处理的相关详细操作（AreaChart3D、AreaChart2D中x，y，z轴添加和颜色设置、字体大小、刻度线显示与颜色等的操作）

AreaChart3D图表数据准备：

目录

AreaChart图表及代码实现

AreaChart3D 图表效果图：

AreaChart3D具体代码实现：

清除网格线：

清除网格线效果图：

AreaChart2D效果图：

AreaChart2D代码实现：

---

AreaChart图表及代码实现

AreaChart3D 图表效果图：

数据准备：

xgRows = [
    ['门派', 'Q1', 'Q2', 'Q3'],
    ['武当派', 1200, 1800, 2200],
    ['崆峒派', 1500, 2000, 2400],
    ['少林派', 1000, 2300, 3200],
    ['峨眉派', 1100, 1750, 2500],
    ['华山派', 1300, 1800, 2700],
    ['昆仑派', 2000, 2800, 3000]
    ]

AreaChart3D具体代码实现：

"""
-*- coding:utf-8 -*-
Group       : Sirius
Author      : Sirius
Time        : 2021-07-05 19:55
Software    : PyCharm
ProjectName : superTable
FileName    : excelAreaChart3D.py
E-mail      : xxxxxx@163.com
"""

from openpyxl import load_workbook
from openpyxl.chart import AreaChart3D, Reference

from openpyxl.chart.text import RichText
from openpyxl.drawing.text import Paragraph, ParagraphProperties, CharacterProperties, Font
from openpyxl.chart.shapes import GraphicalProperties, LineProperties

'''创建和指定活动工作表'''
def createAndActiveSheet(exl, newSheetName):
    newSheet = exl.create_sheet(newSheetName)
    exl.active = exl[newSheetName]
    return newSheet

'''创建一个AreaChart表'''
exl = load_workbook("chartCollections.xlsx")
sheetnames = exl.sheetnames
print(sheetnames)

newSheetName = "areaChart3D"
if newSheetName in sheetnames:
    del exl[newSheetName]
    xgSheet = createAndActiveSheet(exl, newSheetName)
else:
    xgSheet = createAndActiveSheet(exl, newSheetName)

xgRows = [
    ['门派', 'Q1', 'Q2', 'Q3'],
    ['武当派', 1200, 1800, 2200],
    ['崆峒派', 1500, 2000, 2400],
    ['少林派', 1000, 2300, 3200],
    ['峨眉派', 1100, 1750, 2500],
    ['华山派', 1300, 1800, 2700],
    ['昆仑派', 2000, 2800, 3000]
    ]
for row in xgRows:
    xgSheet.append(row)

chart = AreaC