{"text_format":"3","workbook":"xlsx","n_sheets":27,"sheets":["開始","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","深入了解"],"not_rendered":{"charts":29,"images":18,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["歡迎使用\n適用於螢幕助讀程式的指示：瀏覽本教學課程中的祕訣工作表之後，您就可以了解如何快速精通圖表項目。每個工作表的指示都從儲存格 A1 開始，而每個後續步驟則在儲存格 A2、A3 等儲存格中。\n指示會指出要瀏覽到哪個儲存格，以便使用特定功能或進一步閱讀詳細資訊。\n若要開始，請按 CTRL+PAGE DOWN。"]
["超越圓形圖"]
["想要成為圓形圖大師嗎？本教學課程可為您示範做法。\n但是，有時候圓形圖會帶來問題。因此，我們將示範\n如何其他種類的圖表來解決這些問題。 "]
["按 CTRL+HOME 就能回到頁首。若要進行導覽，請按 CTRL+PAGE DOWN。"]

{"sheet":"1","index":1,"n_rows":104,"n_cols":3,"rows_kept":104}
["首先：何時應使用圓形圖？當您需要顯示構成整體的部分 (圖塊) 時。 "]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。"]
["專家級祕訣：這個圓形圖只有四個圖塊。這是理想的，因為它可以讓您快速了解 2019 年 4 月每位銷售代表對銷售量的貢獻。"]
[" 如果您需要使用四個以上的圖塊，另一種圖表可能比較好。(稍候將詳細說明。)"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":94}
[null,"銷售人員","2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"2","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
["建立圓形圖之前，請確定您的資料已正確設定：建立一個類別欄和一個值欄。"]
["儲存格 B9 到 C12 包含資料。有兩個欄：類別和值。[類別] 欄包含的值為棟材、俊文、梨莎和舒慧。[值] 欄包含的值為 NT$1,100、NT$650、NT$500 和 NT$200。"]
["圓形圖的圖片，分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。"]
["要訣詳述：注意類別數目如何決定圓形圖中有多少個圖塊。"]
["並注意，Excel 會在背景自動計算每個值的百分比。然後調整圖塊的大小。您不需要撰寫任何公式！"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"3","index":3,"n_rows":16,"n_cols":3,"rows_kept":16}
["另一件事前工作：在值上方輸入標題。這會作為圓形圖本身的標題，因此請輸入描述性標題。"]
["儲存格 B12 到 C16 包含資料。資料具有描述性標題：2019 年 4 月銷售量。"]
["具有描述性標題的圓形圖圖片：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":7}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"4","index":4,"n_rows":16,"n_cols":3,"rows_kept":16}
["建立圖表前的最後一件工作：排序資料值，由最大到最小。這樣就可以順時針方向輕鬆閱讀圖塊。 "]
["儲存格 B13 到 C16 包含資料。資料的標題為：2019 年 4 月銷售量。共有四列：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。指向資料的箭頭，上有個標籤寫著「此欄從最大到最小排序...」"]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。指向圓形圖的箭頭，上有個標籤寫著「...最大的圖塊將從「12點」位置開始。其餘的圖塊將依順時針方向接著顯示」。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":7}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"5","index":5,"n_rows":15,"n_cols":3,"rows_kept":15}
["練習"]
["1.在儲存格 C11 輸入描述性標題，例如「2019 年 4 月銷售量」。"]
["2.現在，以滑鼠右鍵按一下任何數字，然後選擇 [排序] > [從最大排序到最小] (ALT+A+SD)。"]
["3.選取其中一個帶有數字的儲存格。然後在 [插入] 索引標籤 (ALT + N) 上按一下 [圓形圖] 按鈕 (Q)，然後選取第一個 2D 圓形圖選項。"]
["4.將圓形圖移到更好的位置，然後在視窗頂端按一下 [圖表設計] 索引標籤 (ALT+JC)。然後按一下 [變更色彩] (H) 來挑選一組不同的圖表色彩。"]
["儲存格 B12 到 C15 包含資料。資料有四列：梨莎 NT$500、俊文 NT$650、棟材 NT$1,100、舒慧 NT$200。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"6","index":6,"n_rows":104,"n_cols":3,"rows_kept":104}
["您已完成圓形圖，很棒！但我們可以讓它更臻完美。其中一個方法是使用資料標籤直接為圖塊加上標籤。閱讀以下的「試試看」來了解作法。 "]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊。圓形圖下方列出四個姓名：棟材、俊文、梨莎、舒慧。"]
["試試看：以滑鼠右鍵按一下任何圖塊，然後選擇 [新增資料標籤] (ALT+JC+A+D)。現在您可以看到每個圖塊的實際值。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":95}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"7","index":7,"n_rows":104,"n_cols":3,"rows_kept":104}
["讓資料標籤更臻完美。資料標籤可以顯示值，如下所示。但它們也可以顯示每個類別，因此不需使用圖例。"]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：NT$1,100、NT$650、NT$500 和 NT$200。圓形圖下方列出四個姓名：棟材、俊文、梨莎、舒慧。"]
["試試看：以滑鼠右鍵按一下某個圖塊，然後選擇 [資料標籤格式]。在顯示的窗格中，選取 [類別名稱] 核取方塊。然後在下方將分隔字元設定為 (換行)。現在請以滑鼠右鍵按一下圖例，然後刪除圖例，因為不再需要。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":95}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"8","index":8,"n_rows":104,"n_cols":3,"rows_kept":104}
["資料標籤也可顯示百分比。當您已經知道總計，只是要查看每個圖塊的百分比時，資料標籤很方便。在下面試試看！"]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。"]
["試試看：以滑鼠右鍵按一下某個圖塊，然後選擇 [資料標籤格式]。在顯示的窗格中按一下 [百分比]。加上百分比會讓標籤變得擁擠，因此請直接取消選取 [值] 核取方塊。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":95}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"9","index":9,"n_rows":104,"n_cols":3,"rows_kept":104}
["告訴您一個祕訣：使用色彩來強調及取消強調圖塊。當圖表位於 PowerPoint 投影片，且您需要讓觀眾專注在其中一個圖塊時，這是一個實用的方式。 "]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。除了「俊文 NT$650」圖塊之外，所有圖塊都設為取消強調的灰色，「俊文 NT$650」則是設為強調顯示的黃色。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":96}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"10","index":10,"n_rows":104,"n_cols":3,"rows_kept":104}
["練習使用色彩來強調及取消強調圖塊 "]
["1.以滑鼠右鍵按一下以下其中一個圖塊，然後選擇 [資料數列格式]。然後在 [資料數列格式] 窗格中，按一下 [油漆桶] 圖示。"]
["2.在 [資料數列格式] 窗格中的 [填滿] 底下，於 [色彩] 選項選擇灰色。 "]
["3.現在選取一個圖塊。若要這麼做，按一下圖塊的空白區域，但不要選取資料標籤。圖塊角落出現三個控點時，即表示您已選取該圖塊。"]
["4.以滑鼠右鍵按一下選取的圖塊，然後選擇 [資料點格式]。在 [資料點格式] 窗格中，按一下 [填滿] 圖示，並將 [色彩] 選項變更為橙色、綠色或一些引人注目的色彩。  "]
["圓形圖的圖片，標題為：2019 年 4 月銷售量。此圓形圖分割為四個圖塊：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。每個圖塊都是透過色彩來強調和取消強調圖塊。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":92}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"11","index":11,"n_rows":104,"n_cols":3,"rows_kept":104}
["以下是另一個秘訣：請考慮建立環圈圖。為什麼？有些人發現環圈圖的圓弧比圓形圖的圖塊更容易進行比較。"]
["圓形圖的圖片，分割為四個圖塊：NT$1,100、NT$650、NT$500 和 NT$200。"]
["環圈圖的圖片，分割為四個圖塊：NT$1,100、NT$650、NT$500 和 NT$200。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":95}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]

{"sheet":"12","index":12,"n_rows":104,"n_cols":3,"rows_kept":104}
["練習製作環圈圖"]
["1.在下方資料內按一下。然後在 [插入] 索引標籤 (ALT + N) 上按一下 [圓形圖] 按鈕 (Q)，然後選取 [環圈圖] 選項。"]
["2.您可以視需要移動圖表。然後以滑鼠右鍵按一下任何弧形，再選擇 [資料數列格式]。在環圈圖洞大小中，輸入 [50%]。"]
["3.現在以滑鼠右鍵按一下任何弧形，然後選擇 [新增資料標籤]。以滑鼠右鍵按一下某個弧形，然後選擇 [資料標籤格式]。選取 [類別名稱] 核取方塊。選擇 (換行) 作為分隔符號。刪除圖例。"]
["4.我們製作了以下的總計圓形。現在該您動手了：以滑鼠右鍵按一下，然後選擇 [移到最上層] (ALT+P+AF)。然後將它拖曳到環圈圖內。 "]
["儲存格 B17 到 C21 包含資料。資料的標題為：2019 年 4 月銷售量。共有四列資料：棟材 NT$1,100、俊文 NT$650、梨莎 NT$500、舒慧 NT$200。"]
["黃色總計圓圈的圖片，內有描述：總計：NT$2,450"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":8}
[null,null,"2019 年 4 月銷售量"]
[null,"棟材",{"v":1100,"d":"NT$1,100"}]
[null,"俊文",{"v":650,"d":"NT$650"}]
[null,"梨莎",{"v":500,"d":"NT$500"}]
[null,"舒慧",{"v":200,"d":"NT$200"}]
{"$rows_empty":78}
[null,null,"2019 年 5 月支出"]
[null,"住宅",{"v":2500,"d":"NT$2,500"}]
[null,"交通",{"v":1200,"d":"NT$1,200"}]
[null,"伙食",{"v":800,"d":"NT$800"}]
[null,"服裝",{"v":200,"d":"NT$200"}]

{"sheet":"13","index":13,"n_rows":125,"n_cols":11,"rows_kept":125}
["有時候，圓形圖會帶來問題。以下是其中的一些範例。在下幾個工作表中，我們會說明這些問題以及解決方法。 "]
["彩色 3D 圓形圖的圖片。此圓形圖分割為四個圖塊：棟材、俊文、梨莎、舒慧。"]
["彩色圓形圖的圖片，分割為 14 個圖塊。"]
[" 圓形圖下方列出 14 個標題區段：北園區 B2B 正霖、北園區 B2B 又倫、北園區 B2C 明蒂、南園區 B2B 庭宇、南園區 B2B 贊恩、南園區 B2C 邦良、東園區 B2B 拉斯、北園區 B2B 伊立、北園區 B2C 吉兒、北園區 B2C 詹森、南園區 B2B 珊蒂、南園區 B2C 葛雷、南園區 B2C 立民、東園區 B2B 艾比。"]
["彩色圓形圖的圖片，分割為 9 個圖塊：正霖 NT$2,200、伊立 NT$800、又倫 NT$600、吉兒 NT$500、詹森 NT$300、庭宇 NT$200、珊蒂 NT$200、贊恩 NT$200、葛雷 NT$100。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":92}
[null,"3D 圖表資料",null,null,"許多圖塊的資料",null,null,"階層式資料"]
[]
[null,null,"2019 年 4 月銷售量",null,null,"2020 年 5 月銷售量",null,"園區","類型","辦公室","銷售量"]
[null,"棟材",{"v":800,"d":"NT$800"},null,"正霖",{"v":2200,"d":"NT$2,200"},null,"北園區","B2B","正霖",{"v":300,"d":"NT$300"}]
[null,"俊文",{"v":700,"d":"NT$700"},null,"伊立",{"v":800,"d":"NT$800"},{"$nulls":3},"伊立",{"v":200,"d":"NT$200"}]
[null,"梨莎",{"v":500,"d":"NT$500"},null,"又倫",{"v":600,"d":"NT$600"},{"$nulls":3},"又倫",{"v":400,"d":"NT$400"}]
[null,"舒慧",{"v":200,"d":"NT$200"},null,"吉兒",{"v":500,"d":"NT$500"},null,null,"B2C","吉兒",{"v":100,"d":"NT$100"}]
[{"$nulls":4},"詹森",{"v":300,"d":"NT$300"},{"$nulls":3},"明蒂",{"v":300,"d":"NT$300"}]
[{"$nulls":4},"庭宇",{"v":200,"d":"NT$200"},{"$nulls":3},"詹森",{"v":500,"d":"NT$500"}]
[{"$nulls":4},"珊蒂",{"v":200,"d":"NT$200"},null,"南園區","B2B","庭宇",{"v":600,"d":"NT$600"}]
[{"$nulls":4},"贊恩",{"v":200,"d":"NT$200"},{"$nulls":3},"珊蒂",{"v":400,"d":"NT$400"}]
[{"$nulls":4},"葛雷",{"v":100,"d":"NT$100"},{"$nulls":3},"贊恩",{"v":200,"d":"NT$200"}]
[{"$nulls":8},"B2C","葛雷",{"v":400,"d":"NT$400"}]
[{"$nulls":9},"邦良",{"v":200,"d":"NT$200"}]
[{"$nulls":9},"立民",{"v":600,"d":"NT$600"}]
[{"$nulls":7},"東園區","B2B","拉斯",{"v":1000,"d":"NT$1,000"}]
[{"$nulls":9},"艾比",{"v":300,"d":"NT$300"}]
[{"$nulls":9},"如碧",{"v":200,"d":"NT$200"}]
[{"$nulls":8},"B2C","捷生",{"v":400,"d":"NT$400"}]
[{"$nulls":9},"克儀",{"v":100,"d":"NT$100"}]
[{"$nulls":9},"百勝",{"v":600,"d":"NT$600"}]
[{"$nulls":7},"西園區","B2B","俊文",{"v":600,"d":"NT$600"}]
[{"$nulls":9},"家豪",{"v":100,"d":"NT$100"}]
[{"$nulls":9},"歐力",{"v":1000,"d":"NT$1,000"}]
[{"$nulls":8},"B2C","邁可",{"v":200,"d":"NT$200"}]
[{"$nulls":9},"淑芬",{"v":900,"d":"NT$900"}]
[{"$nulls":9},"美芸",{"v":600,"d":"NT$600"}]

{"sheet":"14","index":14,"n_rows":104,"n_cols":3,"rows_kept":104}
["第一個要注意的問題：3D 圓形圖會使圖塊扭曲，讓前面的圖塊看起來比實際大。一般而言，我們不建議使用 3D 圓形圖。"]
["3D 彩色圓形圖的圖片，分割為 4 個圖塊：欣雯、瑜文、文杉和冠廷。 "]
["指向圓形圖的箭頭，上有個標籤寫著「瑜文的圖塊看起來很大。她真的是業績王嗎？或者只是她的圖塊看起來最大？...」"]
["3D 彩色圓形圖的圖片，分割為 4 個圖塊：欣雯、瑜文、文杉和冠廷。"]
["不過，這個圓形圖新增了資料標籤：欣雯 NT$800、瑜文 NT$700、文杉 NT$500 及冠廷 NT$200。這些標籤顯示欣雯的圖塊才是真正最大的。使用 2D 圓形圖，可以避免扭曲問題。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":93}
[null,null,"2019 年 4 月銷售量"]
[null,"欣雯",{"v":800,"d":"NT$800"}]
[null,"瑜文",{"v":700,"d":"NT$700"}]
[null,"文杉",{"v":500,"d":"NT$500"}]
[null,"冠廷",{"v":200,"d":"NT$200"}]

{"sheet":"15","index":15,"n_rows":110,"n_cols":3,"rows_kept":110}
["圖塊太多是圓形圖的常見問題。如果發生此情況，請考慮變更為另一個圖表，例如直條圖。 "]
["圓形圖的圖片，標題為：2020 年 5 月銷售量。這個圓形圖帶有色彩並分割為十個區塊：正霖 NT$2,200、伊立 NT$800、又倫 NT$600、吉兒 NT$500、明蒂 NT$300、詹森 NT$300、庭宇 NT$200、珊蒂 NT$200、贊恩 NT$200、葛雷 NT$100。"]
["指向圓形圖的箭頭，寫著「問題：此圓形圖有許多圖塊，很難進行比較。」圖塊具有標籤，但是標籤和圖塊太靠近，很難比較資料。"]
["直條圖的圖片，標題為：2020 年 5 月銷售量。直條圖有 10 欄：正霖 NT$2,200、伊立 NT$800、又倫 NT$600、吉兒 NT$500、明蒂 NT$300、詹森 NT$300、庭宇 NT$200、珊蒂 NT$200、贊恩 NT$200、葛雷 NT$100。指向直條圖的箭頭，上有個標籤寫著「解決方法：使用直條圖，就能更輕鬆比較值。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":94}
[null,null,"2020 年 5 月銷售量"]
[null,"正霖",{"v":2200,"d":"NT$2,200"}]
[null,"伊立",{"v":800,"d":"NT$800"}]
[null,"又倫",{"v":600,"d":"NT$600"}]
[null,"吉兒",{"v":500,"d":"NT$500"}]
[null,"明蒂",{"v":300,"d":"NT$300"}]
[null,"詹森",{"v":300,"d":"NT$300"}]
[null,"庭宇",{"v":200,"d":"NT$200"}]
[null,"珊蒂",{"v":200,"d":"NT$200"}]
[null,"贊恩",{"v":200,"d":"NT$200"}]
[null,"葛雷",{"v":100,"d":"NT$100"}]

{"sheet":"16","index":16,"n_rows":110,"n_cols":3,"rows_kept":110}
["練習將圓形圖變更為直條圖。"]
["1.按一下下方的圖表邊界來選取圖表。然後選取視窗上方的 [圖表設計] 索引標籤 (ALT+JC)，選取 [變更圖表類型] (C)。"]
["2.在左邊的清單功能表中，選取 [直條圖]，然後選取 [確定] 或按 Enter 鍵確認選取項目。"]
["3.這個直條圖很好用，但我們不需要垂直和水平軸，因為我們的欄上已經有資料標籤..."]
["4.選取直條圖，然後移至 [圖表設計] 索引標籤 (ALT+JC)。使用 (A+X+V) 命令切換垂直軸，並使用 (A+X+H) 命令切換水平軸。"]
["圓形圖的圖片，標題為：2020 年 5 月銷售量。這個圓形圖帶有色彩並分割為十個區塊：正霖 NT$2,200、伊立 NT$800、又倫 NT$600、吉兒 NT$500、明蒂 NT$300、詹森 NT$300、庭宇 NT$200、珊蒂 NT$200、贊恩 NT$200、葛雷 NT$100。"]
["不過，區塊太多。標籤和圖塊太靠近，很難比較資料。"]
[]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":90}
[null,null,"2020 年 5 月銷售量"]
[null,"正霖",{"v":2200,"d":"NT$2,200"}]
[null,"伊立",{"v":800,"d":"NT$800"}]
[null,"又倫",{"v":600,"d":"NT$600"}]
[null,"吉兒",{"v":500,"d":"NT$500"}]
[null,"明蒂",{"v":300,"d":"NT$300"}]
[null,"詹森",{"v":300,"d":"NT$300"}]
[null,"庭宇",{"v":200,"d":"NT$200"}]
[null,"珊蒂",{"v":200,"d":"NT$200"}]
[null,"贊恩",{"v":200,"d":"NT$200"}]
[null,"葛雷",{"v":100,"d":"NT$100"}]

{"sheet":"17","index":17,"n_rows":105,"n_cols":3,"rows_kept":105}
["其他問題：圓形圖太相似。當這種情況發生時，人們可能會開始環顧四周，懷疑「這裡的關鍵點是什麼？」"]
["圓形圖，標題為：2020 年 6 月銷售量。這個圓形圖帶有色彩並分割為五個區塊：又倫、明蒂、吉兒、正霖、伊立。"]
["指向圓形圖的箭頭，上有個標籤寫著「問題：這些圖塊太相似，我們很難發現有用的資訊。例如：誰是業績最高的銷售人員？」"]
["橫條圖，標題為：2020 年 6 月銷售量。橫條圖有五個橫條：伊立 NT$400、正霖 NT$450、吉兒 NT$500、明蒂 NT$550、又倫 NT$600。"]
["指向橫條圖的箭頭，上有個標籤寫著「解決方法：將圓形圖變更為另一種圖表，如橫條圖。這樣就能看出誰是業績最高的人員：又倫！」"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":93}
[null,null,"2020 年 6 月銷售量"]
[null,"又倫",{"v":600,"d":"NT$600"}]
[null,"明蒂",{"v":550,"d":"NT$550"}]
[null,"吉兒",{"v":500,"d":"NT$500"}]
[null,"正霖",{"v":450,"d":"NT$450"}]
[null,"伊立",{"v":400,"d":"NT$400"}]

{"sheet":"18","index":18,"n_rows":105,"n_cols":3,"rows_kept":105}
["練習將圓形圖變更為橫條圖"]
["1.選取以下的圖表。然後在 [圖表設計] 索引標籤 (ALT+JC) 上選取 [變更圖表類型] (C)。"]
["2.從功能表清單中，選取橫條圖，再選取 [確定] 或使用 Enter 鍵進行確認。"]
["3.此橫條需要清理一下。在選取橫條圖時，移至 [圖表設計] (ALT+JC) 並切換資料標籤 (A+D+N)。"]
["4.現在切換圖表底部的水平軸 (ALT+JC，然後 A+X+H)。(水平軸從 0 開始和 700 結束)。 "]
["具有以下標題的彩色圓形圖圖片：2020 年 6 月銷售量。這個圓形圖帶有色彩並分割為五個區塊：又倫、明蒂、吉兒、正霖、伊立。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":92}
[null,null,"2020 年 6 月銷售量"]
[null,"又倫",{"v":600,"d":"NT$600"}]
[null,"明蒂",{"v":550,"d":"NT$550"}]
[null,"吉兒",{"v":500,"d":"NT$500"}]
[null,"正霖",{"v":450,"d":"NT$450"}]
[null,"伊立",{"v":400,"d":"NT$400"}]

{"sheet":"19","index":19,"n_rows":15,"n_cols":5,"rows_kept":15}
["以下是另一個問題：圓形圖過多。同一個工作表上可以有多個圓形圖，但是對有些人來說，很難針對所有圓形圖和圖塊進行比較。 "]
["儲存格 B12 到 E15 包含資料。資料有三欄：2018、2019 及 2020 年。資料也有三列：玫瑰、鬱金香及鳶尾花。 "]
["圓形圖的圖片，標題為：2018 年。此圓形圖分割為三個圖塊：鬱金香 60%、鳶尾花 33% 和玫瑰 7%。"]
["圓形圖的圖片，標題為：2019 年。此圓形圖分割為三個圖塊：鬱金香 32%、鳶尾花 42% 和玫瑰 25%。"]
["圓形圖的圖片，標題為：2020 年。此圓形圖分割為三個圖塊：鬱金香 27%、鳶尾花 20% 和玫瑰 54%。"]
["指向三個不同圓形圖的箭頭，上有個標籤寫著 「...我們製作了三個圓形圖，以視覺化方式呈現每年。但很難比較每一個圖塊。比較好的選擇是使用直條圖，我們將在下一個工作表中解釋...」"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,null,2018,2019,2020]
[null,"玫瑰",{"v":0.07,"d":"7%"},{"v":0.2542372881355932,"d":"25%"},{"v":0.5357142857142857,"d":"54%"}]
[null,"鬱金香",{"v":0.6,"d":"60%"},{"v":0.3220338983050847,"d":"32%"},{"v":0.26785714285714285,"d":"27%"}]
[null,"鳶尾花",{"v":0.3333333333333333,"d":"33%"},{"v":0.423728813559322,"d":"42%"},{"v":0.19642857142857142,"d":"20%"}]

{"sheet":"20","index":20,"n_rows":109,"n_cols":5,"rows_kept":109}
["練習使用 100% 堆疊直條圖"]
["1.選取以下資料 (B14:E16) 內的任何儲存格，然後在 [插入] 索引標籤 (ALT+N) 上選取插入橫條圖或直條圖選項 (C1)。"]
["2. 然後在平面直條圖下，選取堆疊直條圖。"]
["3.視需要將圖表移到更好的位置。然後在選取橫條圖時，移至 [圖表設計] (ALT+JC) 並切換資料標籤 (A+D+N)。"]
["4.若要設定圖表標題，請移至 [圖表設計] (ALT+JC)、新增圖表元素 (A)、圖表標題 (C)，然後為圖表上方的標題選取 (A)。現在您可以將重點放在標題儲存格，然後輸入花卉銷售量。"]
["儲存格 B13 到 E16 包含資料。資料有三欄：2018、2019 及 2020 年。資料也有三列：玫瑰、鬱金香及鳶尾花。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,null,2018,2019,2020]
[null,"玫瑰",{"v":0.07,"d":"7%"},{"v":0.2542372881355932,"d":"25%"},{"v":0.5357142857142857,"d":"54%"}]
[null,"鬱金香",{"v":0.6,"d":"60%"},{"v":0.3220338983050847,"d":"32%"},{"v":0.26785714285714285,"d":"27%"}]
[null,"鳶尾花",{"v":0.3333333333333333,"d":"33%"},{"v":0.423728813559322,"d":"42%"},{"v":0.19642857142857142,"d":"20%"}]
{"$rows_empty":83}
[null,null,"2019 年銷售量"]
[null,"柏友",{"v":310,"d":"NT$310"}]
[null,"比爾",{"v":305,"d":"NT$305"}]
[null,"書成",{"v":302,"d":"NT$302"}]
[null,"庭宇",{"v":300,"d":"NT$300"}]
[null,"艾迪",{"v":299,"d":"NT$299"}]
[null,"梅玲",{"v":290,"d":"NT$290"}]
[null,"邦良",{"v":286,"d":"NT$286"}]
[null,"麗麗",{"v":268,"d":"NT$268"}]
[null,"金",{"v":260,"d":"NT$260"}]

{"sheet":"21","index":21,"n_rows":36,"n_cols":5,"rows_kept":36}
["其他問題：您擁有階層式資料。圓形圖會試著以視覺化方式呈現此資料，但是會保持在其根目錄，而且只使用一個類別欄和一個值欄。 "]
["儲存格 B12 到 E36 包含資料。資料有四欄：園區、類型、代表，以及第 1 週的銷售量。資料也有 25 列，標示為不同的區段。"]
["有一個括號將儲存格 B12 到 D12群組起來，表示「在這個資料中，就像我們有三個類別欄..」”"]
["有個括號將儲存格 E12 和標籤群組起來，表示「...和一個值欄。」"]
["具有以下標題的彩色圓形圖圖片：第 1 週的銷售量。此圓形圖分割為 24 個圖塊。所有圖塊的標籤列於圓形圖下。"]
["指向圓形圖圖片的箭頭，上有個標籤寫著「Excel 嘗試使用此資料製作圓形圖，但是有很多個圖塊和好幾個圖例！在下一個工作表中，您會看到放射環狀圖較適合呈現此資料。」"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,"園區","類型","代表","第 1 週的銷售量"]
[null,"北園區","B2B","正霖",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"麗麗",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"又倫",{"v":40,"d":"NT$40"}]
[null,null,"B2C","媚卉",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"志明",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"健輝",{"v":50,"d":"NT$50"}]
[null,"南園區","B2B","庭宇",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"珊蒂",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"祖安",{"v":20,"d":"NT$20"}]
[null,null,"B2C","國唯",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"誠雄",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"靜芳",{"v":60,"d":"NT$60"}]
[null,"東園區","B2B","漢克",{"v":100,"d":"NT$100"}]
[{"$nulls":3},"莉華",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"惠恩",{"v":20,"d":"NT$20"}]
[null,null,"B2C","晨怡",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"家貞",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"珮佳",{"v":60,"d":"NT$60"}]
[null,"西園區","B2B","瑜文",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"家豪",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"欣雯",{"v":100,"d":"NT$100"}]
[null,null,"B2C","艾玫",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"雅心",{"v":120,"d":"NT$120"}]
[{"$nulls":3},"秀晴",{"v":60,"d":"NT$60"}]

{"sheet":"22","index":22,"n_rows":36,"n_cols":5,"rows_kept":36}
["放射環狀圖能以視覺化方式呈現階層式資料。這就像外圈是具有不同弧度大小的環圈圖，內圈以視覺方式呈現底層的階層。"]
["儲存格 B12 到 E36 包含資料。資料有四欄：園區、類型、代表，以及第 1 週的銷售量。資料也有 25 列，標示為不同的區段。"]
["一個括號將儲存格 B12 到 D12 群組起來，其標籤表示「此放射環狀圖的內圈使用這三欄...」"]
["一個括號將儲存格 E12 群組起來，其標籤表示「外圈使用這一欄。」"]
["環圈圖的圖片，標題為：第 1 週的銷售量。環圈圖為彩色，具有圖塊弧形 (內有資料標籤)。指向環圈圖的箭頭，上有個標籤寫著「此下是如何閱讀圖表的範例：「在西園區所有 B2C 銷售量中，莉華是第一名銷售人員，緊接著是秀晴和艾玫。」"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"園區","類型","代表","第 1 週的銷售量"]
[null,"北園區","B2B","正霖",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"麗麗",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"又倫",{"v":40,"d":"NT$40"}]
[null,null,"B2C","媚卉",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"志明",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"健輝",{"v":50,"d":"NT$50"}]
[null,"南園區","B2B","庭宇",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"珊蒂",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"祖安",{"v":20,"d":"NT$20"}]
[null,null,"B2C","國唯",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"誠雄",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"靜芳",{"v":60,"d":"NT$60"}]
[null,"東園區","B2B","漢克",{"v":100,"d":"NT$100"}]
[{"$nulls":3},"莉華",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"惠恩",{"v":20,"d":"NT$20"}]
[null,null,"B2C","晨怡",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"家貞",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"珮佳",{"v":60,"d":"NT$60"}]
[null,"西園區","B2B","瑜文",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"家豪",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"欣雯",{"v":100,"d":"NT$100"}]
[null,null,"B2C","艾玫",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"雅心",{"v":120,"d":"NT$120"}]
[{"$nulls":3},"秀晴",{"v":60,"d":"NT$60"}]

{"sheet":"23","index":23,"n_rows":37,"n_cols":5,"rows_kept":37}
["練習將圓形圖變更為放射環狀圖"]
["1.選取下方的圓形圖。然後在 [圖表設計] 索引標籤 (ALT+C) 上選取 [變更圖表類型] (C)。"]
["2.在左側功能表清單上選取 [放射狀環狀圖]，再選取 [確定] 或按 Enter 鍵確認。圖表變更後，選取該圖表，然後切換 [資料標籤] (ALT+JC，然後 A+D)。 "]
["3.若要設定資料標籤的格式，我需要們回到 [新增圖表元素] 選項 (ALT+JC+A)。然後按 (D+M)，取得更多的資料標籤選項。選取 [類別名稱] 和 [值] 的核取方塊。"]
["4.再次進行步驟 1，但這次變更為 [矩形式樹狀結構圖]。現在每個園區都有一種色彩，然後方塊代表每位代表的銷售量。"]
["儲存格 B13 到 E37 包含資料。資料有四欄：園區、類型、代表，以及第 1 週的銷售量。資料也有 25 列，標示為不同的區段。"]
["具有以下標題的彩色圓形圖圖片：第 1 週的銷售量。此圓形圖分割為 24 個圖塊。所有圖塊的標籤列於圓形圖下。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,"園區","類型","代表","第 1 週的銷售量"]
[null,"北園區","B2B","正霖",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"麗麗",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"又倫",{"v":40,"d":"NT$40"}]
[null,null,"B2C","媚卉",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"志明",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"健輝",{"v":50,"d":"NT$50"}]
[null,"南園區","B2B","庭宇",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"珊蒂",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"祖安",{"v":20,"d":"NT$20"}]
[null,null,"B2C","國唯",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"誠雄",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"靜芳",{"v":60,"d":"NT$60"}]
[null,"東園區","B2B","漢克",{"v":100,"d":"NT$100"}]
[{"$nulls":3},"莉華",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"惠恩",{"v":20,"d":"NT$20"}]
[null,null,"B2C","晨怡",{"v":40,"d":"NT$40"}]
[{"$nulls":3},"家貞",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"珮佳",{"v":60,"d":"NT$60"}]
[null,"西園區","B2B","瑜文",{"v":60,"d":"NT$60"}]
[{"$nulls":3},"家豪",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"欣雯",{"v":100,"d":"NT$100"}]
[null,null,"B2C","艾玫",{"v":30,"d":"NT$30"}]
[{"$nulls":3},"雅心",{"v":120,"d":"NT$120"}]
[{"$nulls":3},"秀晴",{"v":60,"d":"NT$60"}]

{"sheet":"24","index":24,"n_rows":21,"n_cols":12,"rows_kept":21}
["開始之前的最後一個工作：有時候您的資料可能尚未彙整。在這些情況下，您必須建立特殊的圖表：樞紐分析圖。 "]
["儲存格 B12 到 D21 包含資料。共有三欄：月、代表與銷售量。有九個包含資料資訊的列。"]
["指向儲存格 B12 到 D21 的箭頭，上有個標籤寫著「此資料尚未彙整。我們需要加總每位代表的銷售量，並將每個加總數字呈現在圓形圖上...」"]
["具有以下標題的彩色圓形圖圖片：總計。此圓形圖分割為三個圖塊：彥亭 120、正霖 135 和 安婕 70。"]
["指向圓形圖的箭頭，上有個標籤寫著「...為了這麼做，我們製作了樞紐分析圖。但它如何彙整每位代表的銷售量呢？"]
["儲存格 K12 到 L16 包含資料。資料有兩欄：列標籤 (具有下拉式功能表) 和銷售量的加總。資料也有五列，包含以下名稱：彥亭、正霖、安婕和銷售量加總的總計。"]
["指向資料的箭頭，上有個標籤寫著「每個樞紐分析圖都會附有樞紐分析表，可加總每位代表的銷售量。」"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[null,"月份","代表","銷售量",{"$nulls":6},"列標籤","加總 - 銷售量"]
[null,"1 月","正霖",{"v":60,"d":"NT$60"},{"$nulls":6},"彥亭",120]
[null,"1 月","彥亭",{"v":20,"d":"NT$20"},{"$nulls":6},"正霖",135]
[null,"1 月","安婕",{"v":30,"d":"NT$30"},{"$nulls":6},"安婕",70]
[null,"2 月","正霖",{"v":15,"d":"NT$15"},{"$nulls":6},"總計",325]
[null,"2 月","彥亭",{"v":50,"d":"NT$50"}]
[null,"2 月","安婕",{"v":30,"d":"NT$30"}]
[null,"3 月","正霖",{"v":60,"d":"NT$60"}]
[null,"3 月","彥亭",{"v":50,"d":"NT$50"}]
[null,"3 月","安婕",{"v":10,"d":"NT$10"}]

{"sheet":"25","index":25,"n_rows":27,"n_cols":4,"rows_kept":27}
["練習建立樞紐分析圖"]
["1.在以下資料中選取任何儲存格 (B18:D27)，然後在 [插入] 索引標籤 (ALT+N) 上選取 [樞紐分析圖] (SZ+C)。"]
["2.在 [建立樞紐分析圖] 對話方塊中，選取 [已經存在的工作表]，然後在 [位置] 方塊中，輸入 F18。選取 [確定] 或按 Enter 鍵確認。"]
["3.在 [樞紐分析表欄位] 窗格中，選取 [代表] 和 [銷售量] 核取方塊項目。然後將圖表移到更好的位置。"]
["4.選取樞紐分析圖。然後移至 [設計] 索引標籤 (ALT+JC)、選取 [變更圖表類型] (C)，再選擇 [圓形圖] 選項。"]
["圓形圖出現後，再次選取該圖表，然後切換 [資料標籤] (ALT+JC，然後 A+D)。"]
["儲存格 B18 到 D27 包含資料。資料有三欄：月、代表與銷售量。資料也有十列，包含以下資料資訊。"]
{"$rows_empty":10}
[null,"月份","代表","銷售量"]
[null,"1 月","正霖",{"v":60,"d":"NT$60"}]
[null,"1 月","彥亭",{"v":20,"d":"NT$20"}]
[null,"1 月","安婕",{"v":30,"d":"NT$30"}]
[null,"2 月","正霖",{"v":15,"d":"NT$15"}]
[null,"2 月","彥亭",{"v":50,"d":"NT$50"}]
[null,"2 月","安婕",{"v":30,"d":"NT$30"}]
[null,"3 月","正霖",{"v":60,"d":"NT$60"}]
[null,"3 月","彥亭",{"v":50,"d":"NT$50"}]
[null,"3 月","安婕",{"v":10,"d":"NT$10"}]

{"sheet":"深入了解","index":26,"n_rows":5,"n_cols":1,"rows_kept":5}
["您已製作出很棒的圓形圖！大功告成。"]
["現在請繼續查看其他連結，協助您加倍提升生產力："]
["深入了解：請參閱這篇文章，了解有關如何建立圓形圖的詳細資料。"]
["試試這個快速鍵：您可以使用此功能自動建立圖表。"]
["社群：提出問題並與其他 Excel 粉絲交流互動"]