- 录入数据:
![C:\Users\JINWAN~1\AppData\Local\Temp\1646301296(1).png](https://www.jingege.wang/wp-content/uploads/2022/03/c-users-jinwan1-appdata-local-temp-16463012961.png)
2. 病例数用Bar图显示,类型1/2用线图呈现,这两个数据分别创建在两个table中:
![C:\Users\JINWAN~1\AppData\Local\Temp\1646301357.png](https://www.jingege.wang/wp-content/uploads/2022/03/c-users-jinwan1-appdata-local-temp-1646301357-pn.png)
![C:\Users\JINWAN~1\AppData\Local\Temp\1646301381(1).png](https://www.jingege.wang/wp-content/uploads/2022/03/c-users-jinwan1-appdata-local-temp-16463013811.png)
3. 根据data1绘制柱状图,并调整相关参数,得到以下data1的柱状图:
4. 双击坐标轴,在弹出窗口中选择Right Y axis,并选择标准(Standard)y轴,设置y轴范围:
5. 双击绘图区,选择Data Sets on Graph,Add添加另外两列,选择Plot on Right Y axis
![](https://www.jingege.wang/wp-content/uploads/2022/03/word-image.png)
![](https://www.jingege.wang/wp-content/uploads/2022/03/image-1.png)
6. 双击柱子,勾选Lines,去掉Bars勾选,并选择Symbol调整颜色,Apply:
![](https://www.jingege.wang/wp-content/uploads/2022/03/image-2-1024x563.png)
7. 其余根据个人喜好审美调整