{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Start","1","2","3","4","5","6","7","8","9","10","Learn more"],"not_rendered":{"charts":7,"images":18,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":3,"n_cols":1,"rows_kept":3}
["Welcome\nInstructions for screen readers: After you go through the tip sheets in this tutorial, you'll learn how to quickly master chart elements. The instructions for each sheet start in cell A1, and each subsequent step is in cell A2, A3, and so on. \nThe instructions will indicate which cells to navigate to for use of a feature, or further reading.\nTo start, press CTRL+PAGE DOWN."]
["Ten tips for charts"]
["After going through these ten charting tips, you'll \nbe faster and more efficient than ever before."]

{"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,"Salesperson","Amount sold"]
[null,"Kelly",500]
[null,"Dave",800]
[null,"Brian",{"v":1000,"d":"1,000"}]
[null,"Sally",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,"Salesperson","Sales","Commission"]
[null,"Kelly",{"v":500,"d":"$500"},{"$f":"0.05*RecommendedChartData3[[#This Row],[Sales]]","v":{"v":25,"d":"$25"}}]
[null,"Dave",{"v":800,"d":"$800"},{"$f":"0.05*RecommendedChartData3[[#This Row],[Sales]]","v":{"v":40,"d":"$40"}}]
[null,"Brian",{"v":1000,"d":"$1,000"},{"$f":"0.05*RecommendedChartData3[[#This Row],[Sales]]","v":{"v":50,"d":"$50"}}]
[null,"Sally",{"v":200,"d":"$200"},{"$f":"0.05*RecommendedChartData3[[#This Row],[Sales]]","v":{"v":10,"d":"$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,"Salesperson","Jan","Feb"]
[null,null,"Kelly",400,500]
[null,null,"Dave",200,800]
[null,null,"Brian",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,"Salesperson","Jan","Feb","Mar","Apr"]
[null,null,"Kelly",800,500,850,123]
[null,null,"Dave",200,800,350,523]
[null,null,"Brian",234,1000,450,574]
[null,null,"Sally",350,550,150,234]
[null,null,"Doris",440,142,645,988]

{"sheet":"5","index":5,"n_rows":18,"n_cols":3,"rows_kept":18}
[]
[]
[]
[]
["4) Press ALT+JT, L to launch the PivotChart Fields pane. Focus will default to the Search text box. Do not type anything, instead, press TAB once. NOTE: if the Field List doesn't launch, press ALT+JT, L again. Press your arrow keys to select the Product field. Once selected, press SPACEBAR to add the Product field to the Rows area. Repeat for the Amount field, and Excel will automatically add it to the Values section. If you're not happy with the PivotChart's placement, you can press ALT+H+FD+P to launch the Selection pane. Then use the TAB key to select the PivotChart, and use your Arrow keys to move the chart wherever you want it. "]
{"$rows_empty":7}
[null,"Product","Amount"]
[null,"Apples",500]
[null,"Apples",800]
[null,"Apples",800]
[null,"Oranges",1000]
[null,"Oranges",200]

{"sheet":"6","index":6,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":12}
[{"$nulls":6},"Department","Product","Amount"]
[{"$nulls":7},"Apples",500]
[{"$nulls":7},"Oranges",800]
[{"$nulls":7},"Bananas",800]
[{"$nulls":7},"Asparagus",600]
[{"$nulls":7},"Broccoli",1000]

{"sheet":"7","index":7,"n_rows":18,"n_cols":9,"rows_kept":18}
[]
[]
[]
[]
[]
["WHY USE A SECONDARY AXIS?\nWhen two columns contain different types of numbers, you'll want to use a secondary axis. In this example, the Sales column contains dollar amounts. But the Profit % column contains percentages. Because the two columns of data are so different, using a combo chart with a secondary axis lets you compare the two columns with different chart elements: columns for Sales, and a line for Profit %."]
[]
[]
[]
[]
[]
[{"$nulls":6},"Date","Sales","Profit %"]
[{"$nulls":6},"2018-01-01",{"v":900,"d":"$900"},{"v":0.33754898404938316,"d":"34%"}]
[{"$nulls":6},"2018-01-02",{"v":600,"d":"$600"},{"v":0.27,"d":"27%"}]
[{"$nulls":6},"2018-01-03",{"v":500,"d":"$500"},{"v":0.42,"d":"42%"}]
[{"$nulls":6},"2018-01-04",{"v":900,"d":"$900"},{"v":0.29,"d":"29%"}]
[{"$nulls":6},"2018-01-05",{"v":700,"d":"$700"},{"v":0.32,"d":"32%"}]
[{"$nulls":6},"2018-01-06",{"v":800,"d":"$800"},{"v":0.23900536726791932,"d":"24%"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":9,"rows_kept":18}
{"$rows_empty":11}
[{"$nulls":6},"Week 1"]
[{"$nulls":6},"Date","Attendance","Food sales"]
[{"$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) Press ALT+H+FD+P top launch the Selection pane, then use your TAB and Arrow keys to navigate to the chart in question. Next, press ALT+JC+C to launch the Change Chart Type dialog. Pie will be selected, so you can press the Tab key twice, then Right Arrow to select the Pie of Pie option. Press enter to confirm your selection."]
[]
["4) Now, press ALT+JA+M, followed by F6, then Tab until you reach the \"Split Series By\" option. Use the Down arrow key, and select the Value option. Tab again to the \"Values less than\" option, enter 1000, then press Enter. When you press Enter, the Kiwis, Grapes, and Pears are split off into their own pie, because each of their amounts is less than 1000.   "]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Product","Amount"]
[{"$nulls":5},"Apples",2500]
[{"$nulls":5},"Pears",30]
[{"$nulls":5},"Grapes",10]
[{"$nulls":5},"Kiwis",15]
[{"$nulls":5},"Oranges",1800]
[{"$nulls":5},"Plums",1200]

{"sheet":"10","index":10,"n_rows":103,"n_cols":6,"rows_kept":103}
{"$rows_empty":99}
[null,"Salesperson","Jan","Feb","Mar","Apr"]
[null,"Kelly",800,1400,1100,1500]
[null,"Dave",200,200,350,523]
[null,"Brian",400,1000,600,800]

{"sheet":"Learn more","index":11,"n_rows":0,"n_cols":0,"rows_kept":0}