《編號(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ú)”，且逆序類(lèi)別調(diào)整系類(lèi)無(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è)置不可見(jiàn)調(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畫(huà)出截?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、叉位置為“最大分類(lèi)”，主要刻度線為“無(wú)”設(shè)置網(wǎng)格線為灰色設(shè)置背景無(wú)顏色步驟4對(duì)三個(gè)小圖表進(jìn)行排版成組圖圖表中分類(lèi)標(biāo)簽為左對(duì)齊，這里使用文本框文字對(duì)齊因EXCEL圖表中默認(rèn)網(wǎng)格線與刻度值有一定距離而商業(yè)圖表都是很靠近的所以這里需要模仿，做法為：復(fù)制一個(gè)一樣大小的圖表，底層只留刻度標(biāo)簽，其他設(shè)置無(wú)顏色頂層圖表設(shè)置無(wú)刻度值，然后兩個(gè)圖表重疊，把頂層圖表往上拉一點(diǎn)，讓其與底層刻度靠近圖1與圖2排版好后，底部各畫(huà)一個(gè)矩形填充白色放置圖表最底層作為背景再繪制一個(gè)矩形填充灰色，放在兩個(gè)圖表最低端，遮住漏出來(lái)的一部分網(wǎng)格線，讓系列與網(wǎng)格線平行第三個(gè)圖表排版與上面圖表一樣，復(fù)制兩個(gè)重疊用直線與文本框作為系列線與

13、數(shù)據(jù)標(biāo)記畫(huà)矩形作為第三個(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è)圖表最低端，遮住漏出來(lái)的一部分網(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