import pandas as pdimport numpy as npmydata=pd.dataframe({"name":["苹果","谷歌","**","亚马逊","腾讯"],"conpany":["apple","google","**","amozon","tencent"],"sale2013":[5000,3500,2300,2100,3100],"sale2014":[5050...
1准备数据新建工作薄,添加数据集,sql语句为select * from [销量],查询所有销售人员的产品销量情况,直接作为图表数据源,制作销量统计图。2插入图表以悬浮图表为例,点击插入>悬浮元素>插入图表,弹出图表向导对话框,选择柱形图,点击确定;3设置图表数据图表数据来源于数据集数据,设置如下图,点击完成:4 **设置选中图表,点击图表属性表-样式>坐标轴>分析线,点击...