《編號(hào) (120)》由會(huì)員分享,可在線閱讀,更多相關(guān)《編號(hào) (120)(11頁(yè)珍藏版)》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、%responding:datamonitor heaith48send/receive nobfications46search45track daity activity45take pictures,audio,video43tell time42track exercise41access video/audio content38control smart home28make mobite payments28share health and data25fashion accessory25work purposes24%of respondents data截?cái)嗾`差2insur
2、ance(for definite discount)7038#N/Abrand(for lower prices)6938#N/Adoctor6838#N/Ahealth industry subsidy67380insurance(for potential discount)6738#N/A50403020100famity6638#N/Afriends6438#N/Abrand(advertising and promotion)6138#N/Aemployer5938Price respondents are wilting to paydata100 or less11101-20
3、024201-30025301-40020401-50011501-6006Over 60031234567801234567891070656055504540357065605550454035100 or less 101-200201-300301-400401-500501-600Over 6000510152025monitor heaithsend/receivenobficationssearchtrack daity activitytake pictures,audio,videotell timetrack exerciseaccess video/audio conte
4、ntcontrol smart homemake mobite work purposesfashion accessoryshare health and data0510152025Price respondents are wilting to payEntry-level appleWatch:$349Source:Morgan Stanley Research*Based on a survey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014Weara
5、ble devices Reason for prospective purchase%responding:%of respondents very likely or somewhat likelyto share data with:insurance definite brand(for lower doctorhealth industrysubsidyinsurance(fpotential famityfriendsbrandand employer100 or less201-300301-400401-500501-600Over 6000102030405035404550
6、55606570monitor heaithsend/receivenobficationssearchtrack daity activitytake pictures,audio,videotell timetrack exerciseaccess video/audio contentcontrol smart homemake mobite work purposesfashion accessoryshare health and data0510152025Price respondents are wilting to payEntry-level appleWatch:$349
7、Source:Morgan Stanley Research*Based on a survey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014Wearable devices Reason for prospective purchase%responding:%of respondents very likely or somewhat likelyto share data with:insurance definite brand(for lower d
8、octorhealth industrysubsidyinsurance(fpotential famityfriendsbrandand employer100 or less201-300301-400401-500501-600Over 600010203040503540455055606570作圖數(shù)據(jù)第一組數(shù)據(jù)第二組數(shù)據(jù)%responding:data%of respondents monitor heaith48insurance(for definite discount)send/receive nobfications46brand(for lower prices)sear
9、ch45doctortrack daity activity45health industry subsidytake pictures,audio,video43insurance(for potential discount)tell time42famitytrack exercise41friendsaccess video/audio content38brand(advertising and promotion)control smart home28employermake mobite payments28share health and data25fashion acce
10、ssory25work purposes24步驟1選擇第一組數(shù)據(jù)插入條形圖刪除圖例,刪除標(biāo)題設(shè)置縱坐標(biāo)標(biāo)簽為“無(wú)”刻度線為“無(wú)”,且逆序類別調(diào)整系類無(wú)間距為“40”設(shè)置刻度值最小為0,最大為50,間距為10,線條為“無(wú)”設(shè)置系列為RGB值為0,163,219設(shè)置背景色為無(wú)填充無(wú)線條設(shè)置網(wǎng)格線為灰色步驟2方法1第二組數(shù)據(jù)需要對(duì)其進(jìn)行處理因圖表網(wǎng)格線中有不同顏色突出使用柱形圖制作散點(diǎn)圖選擇誤差2的數(shù)據(jù)插入柱形圖刪除圖例,刪除標(biāo)題50403020100設(shè)置刻度值最大值為10選中柱形圖添加誤差線選中誤差線那設(shè)置為“正偏差”“無(wú)線端”固定值為“10”顏色為“紅”線粗為“1”設(shè)置橫坐標(biāo)軸在刻度線上選擇數(shù)據(jù)
11、與截?cái)鄶?shù)據(jù)黏貼到圖表中,選擇新系列把新系列改成條形圖把主縱坐標(biāo)與橫坐標(biāo)設(shè)置不可見調(diào)出次要縱坐標(biāo)設(shè)置次要橫坐標(biāo) 坐標(biāo)交叉位置設(shè)置為“自動(dòng)”,刻度值最大為70,最小為35,間距為5,無(wú)線條設(shè)置次要縱坐標(biāo)為逆序刻度,橫坐標(biāo)軸交叉為“自動(dòng)”,分列不顯示,線條設(shè)置為白色,線粗比網(wǎng)格線粗即可調(diào)出次要縱網(wǎng)格線設(shè)置條形圖的重疊為100,間距為30畫出截?cái)鄨D形,填充白色,復(fù)制圖形后選擇截?cái)鄶?shù)據(jù)黏貼設(shè)置系列顏色設(shè)置橫坐標(biāo)數(shù)字顯示格式紅色=500;350;設(shè)置背景無(wú)填充網(wǎng)格線灰色步驟3選擇第三組數(shù)據(jù)插入柱形圖設(shè)置刻度值為最大25,最小為0,設(shè)置無(wú)線條選中系列,設(shè)置分列間距為30,顏色設(shè)置為藍(lán)色選中橫坐標(biāo)設(shè)置縱坐標(biāo)交
12、叉位置為“最大分類”,主要刻度線為“無(wú)”設(shè)置網(wǎng)格線為灰色設(shè)置背景無(wú)顏色步驟4對(duì)三個(gè)小圖表進(jìn)行排版成組圖圖表中分類標(biāo)簽為左對(duì)齊,這里使用文本框文字對(duì)齊因EXCEL圖表中默認(rèn)網(wǎng)格線與刻度值有一定距離而商業(yè)圖表都是很靠近的所以這里需要模仿,做法為:復(fù)制一個(gè)一樣大小的圖表,底層只留刻度標(biāo)簽,其他設(shè)置無(wú)顏色頂層圖表設(shè)置無(wú)刻度值,然后兩個(gè)圖表重疊,把頂層圖表往上拉一點(diǎn),讓其與底層刻度靠近圖1與圖2排版好后,底部各畫一個(gè)矩形填充白色放置圖表最底層作為背景再繪制一個(gè)矩形填充灰色,放在兩個(gè)圖表最低端,遮住漏出來的一部分網(wǎng)格線,讓系列與網(wǎng)格線平行第三個(gè)圖表排版與上面圖表一樣,復(fù)制兩個(gè)重疊用直線與文本框作為系列線與
13、數(shù)據(jù)標(biāo)記畫矩形作為第三個(gè)圖表背景選擇整個(gè)圖表區(qū)域設(shè)置單元格顏色為灰色7065605550454035100 or less 101-200201-300301-400401-500501-600Over 6000510152025monitor heaithsend/receivenobficationssearchtrack daity activitytake pictures,audio,videotell timetrack exerciseaccess video/audio contentcontrol smart homemake mobite work purposesfash
14、ion accessoryshare health and data0510152025Price respondents are wilting to payEntry-level appleWatch:$349Source:Morgan Stanley Research*Based on a survey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014Wearable devices Reason for prospective purchase%respo
15、nding:%of respondents very likely or somewhat likelyto share data with:insurance definite brand(for lower doctorhealth industrysubsidyinsurance(fpotential famityfriendsbrandand employer100 or less201-300301-400401-500501-600Over 600010203040503540455055606570進(jìn)行美化monitor heaithsend/receivenobfication
16、ssearchtrack daity activitytake pictures,audio,videotell timetrack exerciseaccess video/audio contentcontrol smart homemake mobite work purposesfashion accessoryshare health and data0510152025Price respondents are wilting to payEntry-level appleWatch:$349Source:Morgan Stanley Research*Based on a sur
17、vey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014Wearable devices Reason for prospective purchase%responding:%of respondents very likely or somewhat likelyto share data with:insurance definite brand(for lower doctorhealth industrysubsidyinsurance(fpotenti
18、al famityfriendsbrandand employer100 or less201-300301-400401-500501-600Over 600010203040503540455055606570第三組數(shù)據(jù)第二組輔助dataPrice respondents are wilting to paydata誤差1 誤差2 截?cái)?0100 or less110.23869101-200240.23868201-300250.23867301-400200.23867401-500110.23866501-60060.23864Over 60030.238610.2385938選中誤
19、差線那設(shè)置為“正偏差”“無(wú)線端”固定值為“10”顏色為“紅”線粗為“1”設(shè)置次要橫坐標(biāo) 坐標(biāo)交叉位置設(shè)置為“自動(dòng)”,刻度值最大為70,最小為35,間距為5,無(wú)線條設(shè)置次要縱坐標(biāo)為逆序刻度,橫坐標(biāo)軸交叉為“自動(dòng)”,分列不顯示,線條設(shè)置為白色,線粗比網(wǎng)格線粗即可所以這里需要模仿,做法為:復(fù)制一個(gè)一樣大小的圖表,底層只留刻度標(biāo)簽,其他設(shè)置無(wú)顏色頂層圖表設(shè)置無(wú)刻度值,然后兩個(gè)圖表重疊,把頂層圖表往上拉一點(diǎn),讓其與底層刻度靠近再繪制一個(gè)矩形填充灰色,放在兩個(gè)圖表最低端,遮住漏出來的一部分網(wǎng)格線,讓系列與網(wǎng)格線平行monitor heaithsend/receivenobficationssearchtr
20、ack daity activitytake pictures,audio,videotell timetrack exerciseaccess video/audio contentcontrol smart homemake mobite paymentswork purposesfashion accessoryshare health and data0510152025Price respondents are wilting to pay$Entry-level appleWatch:$349Source:Morgan Stanley Research*Based on a sur
21、vey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014Wearable devices survey*Reason for prospective purchase%responding:%of respondents very likely or somewhat likelyto share data with:insurance(fordefinite discount)brand(for lower prices)doctorhealth industr
22、ysubsidyinsurance(forpotential discount)famityfriendsbrandand promotion)employer100 or less201-300301-400401-500501-600Over 600504030201007065605550454035monitor heaith48search45track daity activity45take pictures,audio,video43tell time42track exercise41access video/audiocontent38control smart home2
23、8make mobite payments28share health and data25fashion accessory25work purposes240510152025*Based on a survey of 10,500 people in Britain,Brazit,ChinaFrance,Germany,Japan and United States,August 2014%of respondents very likely or somewhat likelyto share data with:100 or less201-300301-400401-500501-600Over 6007065605550454035insurance(for definitediscount)700.238 100 or less11doctor680.238 201-30025health industry subsidy670.238 301-40020insurance(for potential discount)670.238 401-50011famity660.238 501-6006friends640.238 Over 6003brand(advertising and promotion)610.238employer5938