openpyxl逆序刻度值
时间: 2023-09-30 09:13:23 浏览: 242
在使用openpyxl进行逆序刻度值设置时,需要注意以下几点。首先,需要使用scaling.orientation属性来实现逆序刻度,该属性有两个可选值,分别是"minMax"和"maxMin",分别表示从小到大和从大到小的刻度顺序。另外,需要注意在设置逆序刻度时,不能直接使用scaling.min和scaling.max属性进行设定,因为在openpyxl中,min的值永远只能比max小。因此,需要通过scaling.crosses属性来设置坐标轴的交叉点,然后再配合scaling.orientation属性来实现逆序刻度的效果。 <span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [openpyxl操作之散点图:坐标轴交叉、逆序刻度值、次坐标轴等](https://blog.csdn.net/y_996/article/details/120969729)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [Python绘图记录专栏](https://blog.csdn.net/u012848304/article/details/119347010)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文