# 图11-1-3 (e)商业图表_商业周刊
```python
import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
plt.rcParams["font.sans-serif"] = 'Arial'
# plt.rcParams["font.sans-serif"]='SimHei' # 汉字显示设定
plt.rcParams['axes.unicode_minus'] = False
plt.rcParams['axes.facecolor'] = 'w'
plt.rcParams['savefig.facecolor'] = 'w'
plt.rc('axes', axisbelow=False) # 使网格线置于图表下层
df = pd.read_excel(r"多数据系列柱形图.xlsx", sheet_name="原始数据")
# df=df.sort_values("INFO-Processing",ascending=False) # 降序处理
df
```
```
Quarter TOTAL INFO-Processing
0 '04 III 18 8
1 IV 19 18
2 '05 I 7 24
```
```python
x_lable = np.array(df["Quarter"])
x = np.arange(len(x_lable))
y1 = np.array(df["TOTAL"])
y2 = np.array(df["INFO-Processi
