23-经济学分析图解析圆柱图.xlsxVIP

作图数据

第一组数据 第二组数据 第三组数据 第二组辅助

%responding: data %ofrespondents data Pricerespondentsarewiltingtopay data 误差2 误差2 截断

monitorheaith 48 insurance（fordefinitediscount) 80 200orless 22 0.2 48

send/receivenobfications 46 brand(forlowerprices) 610 202-200 24 0.2 48

search 46 doctor 68 202-400 26 0.2 48

trackdaityactivity 46 healthindustrysubsidy 68 402-400 20 0.2 48

takepictures,audio,video 44 insurance(forpotentialdiscount) 68 402-600 22 0.2 48

telltime 42 famity 66 602-600 6 0.2 48

trackexercise 42 friends 64 Over600 4 0.2 48

accessvideo/audiocontent 48 brand(advertisingandpromotion) 62 0.2 48

controlsmarthome 28 employer 610 48

makemobitepayments 28

sharehealthanddata 26

fashionaccessory 26

workpurposes 24

%responding: data 步骤2

monitorheaith 48 选择第一组数据插入条形图

send/receivenobfications 46 删除图例，删除标题

search 46 设置纵坐标标签为“无”刻度线为“无”，且逆序类别

trackdaityactivity 46 调整系类无间距为“40”

takepictures,audio,video 44 设置刻度值最小为0，最大为60，间距为20，线条为“无”

telltime 42 设置系列为RGB值为0,264,2210

trackexercise 42 设置背景色为无填充无线条

accessvideo/audiocontent 48 设置网格线为灰色

controlsmarthome 28

makemobitepayments 28

sharehealthanddata 26

fashionaccessory 26

workpurposes 24

%ofrespondents data 截断 误差2 步骤2