{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["開始","1","2","3","4","5","6","7","8","9","10","深入了解"],"not_rendered":{"charts":7,"images":17,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":3,"n_cols":1,"rows_kept":3}
["歡迎使用\n適用於螢幕助讀程式的指示：瀏覽本教學課程中的祕訣工作表之後，您就可以了解如何快速精通圖表項目。每個工作表的指示都從儲存格 A1 開始，而每個後續步驟則在儲存格 A2、A3 等儲存格中。\n指示會指出要瀏覽到哪個儲存格，以便使用特定功能或進一步閱讀詳細資訊。\n若要開始，請按 CTRL+PAGE DOWN。"]
["適用於圖表的十個祕訣"]
["瀏覽完這十個圖表製作祕訣後，您的\n速度和效率均會更勝以往。"]

{"sheet":"1","index":1,"n_rows":16,"n_cols":12,"rows_kept":16}
{"$rows_empty":8}
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"Click Next to continue...\",\" \")","v":" "}]
[null,"銷售人員","已銷售的金額"]
[null,"梨莎",500]
[null,"俊文",800]
[null,"棟材",{"v":1000,"d":"1,000"}]
[null,"舒慧",200]

{"sheet":"2","index":2,"n_rows":16,"n_cols":12,"rows_kept":16}
{"$rows_empty":8}
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"Click Next to continue...\",\" \")","v":" "}]
[null,"銷售人員","銷售","佣金"]
[null,"梨莎",{"v":500,"d":"NT$500"},{"$f":"0.05*建議的圖表資料3[[#This Row],[銷售]]","v":{"v":25,"d":"NT$25"}}]
[null,"俊文",{"v":800,"d":"NT$800"},{"$f":"0.05*建議的圖表資料3[[#This Row],[銷售]]","v":{"v":40,"d":"NT$40"}}]
[null,"棟材",{"v":1000,"d":"NT$1,000"},{"$f":"0.05*建議的圖表資料3[[#This Row],[銷售]]","v":{"v":50,"d":"NT$50"}}]
[null,"舒慧",{"v":200,"d":"NT$200"},{"$f":"0.05*建議的圖表資料3[[#This Row],[銷售]]","v":{"v":10,"d":"NT$10"}}]

{"sheet":"3","index":3,"n_rows":16,"n_cols":12,"rows_kept":16}
{"$rows_empty":8}
[{"$nulls":11},{"$f":"IF(AND($C$15=\"Buyer\",$I$18=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($C$15=\"Buyer\",$I$18=1175),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":10},{"$f":"IF(AND($C$15=\"Buyer\",$I$18=1175),\"Click Next to continue...\",\" \")","v":" "}]
[]
[null,null,"銷售人員","1月","2月"]
[null,null,"梨莎",400,500]
[null,null,"俊文",200,800]
[null,null,"棟材",234,1000]

{"sheet":"4","index":4,"n_rows":105,"n_cols":12,"rows_kept":105}
{"$rows_empty":8}
[{"$nulls":11},{"$f":"IF(AND($C$102=\"Buyer\",$I$18=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($C$102=\"Buyer\",$I$18=1175),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($C$102=\"Buyer\",$I$18=1175),\"Click Next to continue...\",\" \")","v":" "}]
{"$rows_empty":88}
[null,null,"銷售人員","1月","2月","3月","4月"]
[null,null,"梨莎",800,500,850,123]
[null,null,"俊文",200,800,350,523]
[null,null,"棟材",234,1000,450,574]
[null,null,"舒慧",350,550,150,234]
[null,null,"家貞",440,142,645,988]

{"sheet":"5","index":5,"n_rows":18,"n_cols":3,"rows_kept":18}
[]
[]
[]
[]
["4) 按 ALT+JT，L 以啟動 [樞紐分析圖欄位] 窗格。焦點會預設為 [搜尋] 文字方塊。請勿輸入任何內容，而是按一次 TAB。注意：如果 [欄位清單] 沒有啟動，請再按 ALT+JT，L 一次。按方向鍵以選取 [產品] 欄位。選取之後，按空格鍵以將 [產品] 欄位新增到 [列] 區域。為 [金額] 欄位重複執行此操作，Excel 會自動將它新增到 [值] 區段。如果您不滿意樞紐分析圖的位置，您可以按 ALT+H+FD+P 以啟動 [選取窗格]。接著，使用 TAB 鍵選取 [樞紐分析圖]，然後使用方向鍵將圖表移動到任何想要的位置。 "]
{"$rows_empty":7}
[null,"產品","金額"]
[null,"蘋果",500]
[null,"蘋果",800]
[null,"蘋果",800]
[null,"橘子",1000]
[null,"橘子",200]

{"sheet":"6","index":6,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":12}
[{"$nulls":6},"部門","產品","金額"]
[{"$nulls":7},"蘋果",500]
[{"$nulls":7},"橘子",800]
[{"$nulls":7},"香蕉",800]
[{"$nulls":7},"蘆筍",600]
[{"$nulls":7},"花椰菜",1000]

{"sheet":"7","index":7,"n_rows":18,"n_cols":9,"rows_kept":18}
[]
[]
[]
[]
[]
["為什麼要使用副座標軸？\n當兩欄包含不同類型的數字時，您會想要使用副座標軸。在此範例中，[銷售] 欄包含金額。但 [利潤 %] 欄包含百分比。因為這兩欄的資料如此不同，使用具有副座標軸的組合式圖表可讓您比較具有不同圖表元素的兩欄：[銷售] 的直條和 [利潤 %] 的折線。"]
[]
[]
[]
[]
[]
[{"$nulls":6},"日期","銷售","利潤 %"]
[{"$nulls":6},"2018-01-01",{"v":900,"d":"NT$900"},{"v":0.33754898404938316,"d":"34%"}]
[{"$nulls":6},"2018-01-02",{"v":600,"d":"NT$600"},{"v":0.27,"d":"27%"}]
[{"$nulls":6},"2018-01-03",{"v":500,"d":"NT$500"},{"v":0.42,"d":"42%"}]
[{"$nulls":6},"2018-01-04",{"v":900,"d":"NT$900"},{"v":0.29,"d":"29%"}]
[{"$nulls":6},"2018-01-05",{"v":700,"d":"NT$700"},{"v":0.32,"d":"32%"}]
[{"$nulls":6},"2018-01-06",{"v":800,"d":"NT$800"},{"v":0.23900536726791932,"d":"24%"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":11}
[{"$nulls":6},"第 1 週"]
[{"$nulls":6},"日期","出席人數","食物銷售"]
[{"$nulls":6},"2018-01-01",599,900]
[{"$nulls":6},"2018-01-02",201,400]
[{"$nulls":6},"2018-01-03",459,500]
[{"$nulls":6},"2018-01-04",234,900]
[{"$nulls":6},"2018-01-05",622,900]

{"sheet":"9","index":9,"n_rows":18,"n_cols":7,"rows_kept":18}
[]
[]
["2) 按 ALT+H+FD+P 以啟動 [選取窗格]，然後使用 TAB 和方向鍵瀏覽到要處理的圖表。接下來，按 ALT+JC+C 以啟動 [變更圖表類型] 對話方塊。系統將會選取 [圓形圖]，因此您可以按兩次 Tab 鍵，然後按向右鍵以選取 [子母圓形圖] 選項。按 Enter 以確認您的選擇。"]
[]
["4) 現在，按 ALT+JA+M，接著再按 F6，然後按 Tab，直到您到達 [數列分割方式] 選項為止。使用向下鍵，然後選取 [值] 選項。再次按 Tab 以移至 [值小於] 選項，輸入 1000，然後按 Enter。當您按 Enter 時，[奇異果]、[葡萄] 和 [梨子] 會分離為各自的圓形圖，因為每個的金額都小於 1000。   "]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"產品","金額"]
[{"$nulls":5},"蘋果",2500]
[{"$nulls":5},"梨子",30]
[{"$nulls":5},"葡萄",10]
[{"$nulls":5},"奇異果",15]
[{"$nulls":5},"橘子",1800]
[{"$nulls":5},"李子",1200]

{"sheet":"10","index":10,"n_rows":103,"n_cols":6,"rows_kept":103}
{"$rows_empty":99}
[null,"銷售人員","1月","2月","3月","4月"]
[null,"梨莎",800,1400,1100,1500]
[null,"俊文",200,200,350,523]
[null,"棟材",400,1000,600,800]

{"sheet":"深入了解","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}