{"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":17,"external_links":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["Welcome\nInstructions for screen readers: Once you’ve gone 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."]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":16,"n_cols":12,"rows_kept":16}
["Tip No. 1: Press ALT+F1 to quickly make a chart."]
["1) There’s data in cells B12 to C16. Navigate anywhere within that range."]
["2) Press ALT+F1 (make sure that your F-Lock key is on). If you’re using a laptop, try ALT+FN+F1."]
["3) Excel creates a simple chart for you. "]
["4) Press ALT+JC+C to activate the Change Chart Type dialogue, and use your TAB and Arrow keys to pick an other chart that interests you."]
["BONUS TIP\nDon’t like the default chart type for ALT+F1? On the Design tab, click Change Chart Type, then right-click the chart you like better and choose Set as Default Chart."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$17=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$17=1175),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":11},{"$f":"IF(AND($B$14=\"Buyer\",$I$17=1175),\"Click Next to continue...\",\" \")","v":" "}]
[null,"Salesperson","Amount sold"]
[null,"Kate",500]
[null,"Dave",800]
[null,"Ben",{"v":1000,"d":"1,000"}]
[null,"Sally",200]

{"sheet":"2","index":2,"n_rows":16,"n_cols":12,"rows_kept":16}
["Tip NO. 2: Select specific columns, before creating a chart."]
["1) Press Ctrl+G to activate the Go To dialogue."]
["2) Enter B12:B16, D12:D16 to select the Salesperson and Commission columns, but exclude the Sales column."]
["3) Press ALT+F1 (make sure that your F-Lock key is on). If you’re using a laptop, try ALT+FN+F1."]
["4) Excel creates a chart based on the Salesperson and Commission columns only. It excluded the Sales column from the chart. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[{"$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,"Kate",{"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,"Ben",{"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}
["Tip No. 3: Use a table with a chart."]
["1) There is chart data in cells C13 to E16. Navigate to any cell within that range, then press CTRL+T to convert the range to a table."]
["2) In cell F13, type Mar and then press Enter. The table automatically expands to include the new column. "]
["3) Type some numbers for each salesperson in the March column, in cells E14 to E16."]
["4) Notice the chart legend now has an entry for Mar, as well as the bars. That’s the advantage of using a table with a chart: Any new columns or rows will be automatically reflected in the chart."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[{"$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,"Kate",400,500]
[null,null,"Dave",200,800]
[null,null,"Ben",234,1000]

{"sheet":"4","index":4,"n_rows":105,"n_cols":12,"rows_kept":105}
["Tip No. 4: Quickly filter data from a chart."]
["1) Let’s imagine that you don’t want this chart to include Doris’ data. "]
["2) Press ALT+H+FD+P to launch the Selection Pane, then press Tab and Arrow keys to select Chart 4."]
["3) Press ALT+JC+E to launch the Select Data Source dialog, and press TAB and Arrow key until you get to the Series you want to exclude, in this case, Doris. Press CTRL+SHIFT+Down Arrow, then SPACEBAR to untick that item. Press Enter to dismiss the pane."]
["4) The chart now excludes Doris’ data (you can repeat the previous steps to bring the data back if you want)."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[{"$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,"Kate",800,500,850,123]
[null,null,"Dave",200,800,350,523]
[null,null,"Ben",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}
["Tip No. 5: Use PivotCharts when your data isn’t summarised."]
["1) In cells B13 to C18 below, “Apples” and “Oranges” are repeated in several rows. This is called unsummarised data. Unfortunately, regular charts prefer the data to be summarised…"]
["2) …but PivotCharts can handle this task! Navigate to any cell within range B13 to C18 in the table below. Then Press ALT+N+SZ+C (Insert > PivotChart)."]
["3) Press TAB, Down Arrow, then TAB to navigate to the Existing Worksheet > Location input box, type E13 and press Enter. Excel will create a blank PivotTable and chart for you."]
["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. "]
["BONUS TIP\nUse ALT+H+FD+P and then Tab to navigate to the chart. Press Enter to select the chart, and now press SHIFT+Left Arrow several times. The chart gets narrower. Press SHIFT+Right Arrow to make it wider. Guess what pressing SHIFT+Up or Down Arrow does?"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[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}
["Tip No. 6: Create multi-level labels"]
["1) Wouldn’t this chart be better if it had another level of labels at the bottom, that organised the columns by either “Fruits” or “Vegetables”?"]
["2) In cell G14, type the word “Fruits”. And in cell G17, type the word “Vegetables”."]
["3) Press ALT+H+FD+P to launch the Selection pane, then use the TAB key to navigate to the chart in question. Then press ALT+JC+E to launch the Select Data Source dialogue."]
["4) With the dialogue box open, use your Arrow keys to navigate to cell G14, then hold the SHIFT key down and use the Arrow keys to select cells G14 to I18, and then press Enter. The chart now has another level of labels for “Fruits” and “Vegetables”. "]
["GOOD TO KNOW\nThis only works if your rows have already been organised in groups. In the example below, the rows for fruits are grouped together, and so are the rows for vegetables."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[{"$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}
["Tip No. 7: Use a secondary axis to create a combo chart."]
["1) The chart below has two data series: Sales and Profit %. But we need Profit % to be represented by a horizontal line on the chart, not a column."]
["2) Press ALT+H+FD+P to launch the selection pane, then use the TAB and Arrow keys to navigate to the chart in question. Next, press ALT+JC+C to launch the Change Chart Type dialogue. Now, press Tab once and then Arrow down until you can select Combo."]
["3) Press TAB until the Series Name section has been selected, then arrow down once to the Profit % item. Tab to the Chart type, and if it’s not a Line chart, use your Down Arrow key to select Line. Press Tab again to select the Secondary Axis tick box and use the SPACEBAR to tick it."]
["4) Press Enter, and the Profit % will be plotted with a line. Now you can compare the two series. For example, sales were low on 03/01/2018, but profit was great!"]
["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. As 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 %."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[{"$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}
["Tip No. 8: Hook up a chart title to a cell."]
["1) The chart below is called “Chart Title”. That’s not very helpful, so let’s change that. "]
["2) Press ALT+H+FD+P top launch the Selection pane and then use your TAB and Arrow keys to navigate to the chart in question. Press Enter to select it, which will also select the current Chart Title text box. "]
["3) Press F2 to activate the Formula Bar, and type =’8’!G12."]
["4) Press Enter. The chart title is now “Week 1” – that’s so much better. And from now on, the chart title will always show what’s in cell G12. (Try it out by typing something else in the cell G12 and pressing Enter)."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[{"$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}
["Tip No. 9: Split off slices into a second pie"]
["1) We need to make a “pie of pie” chart, where the Kiwis, Grapes and Pears are “split off” into their own pie. "]
["2) Press ALT+H+FD+P top launch the Selection pane and 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 dialogue. 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."]
["3) Next, we want to format the smaller pie’s data series, so press ALT+JA+E, Down Arrow to Series “Amount” and then press Enter. "]
["4) Now, press ALT+JA+M followed by F6, then Tab until you’ve reached the “Split Series By” option. Use the Down arrow key and select the Value option. Tab again to the “Values less than” option, enter 1,000 and then press Enter. When you press Enter, the Kiwis, Grapes,and Pears are split off into their own pie as each of their amounts is less than 1,000.   "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[{"$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}
["Tip No. 10: Hover over Chart Elements to get a preview."]
["1) What would this chart look like with a legend? With data labels?  "]
["2) Press ALT+H+FD+P to launch the Selection pane, then use your Tab and Arrow keys to navigate to the chart in question."]
["3) Next, press ALT+JC+L to activate the Quick Layout gallery. You can use your Arrow keys to browse between 12 different options, such as Chart Title on top with a Legend on the bottom. "]
["4) Press Enter to apply a selection, or press ESC to exit without making any changes."]
["WORTH EXPLORING\nClick the chart, and on the Design tab, hovering over a quick layout, colour option or style will give you a live preview. This gives you a chance to see how something will look without having to actually apply it first."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":92}
[null,"Salesperson","Jan","Feb","Mar","Apr"]
[null,"Kate",800,1400,1100,1500]
[null,"Dave",200,200,350,523]
[null,"Ben",400,1000,600,800]

{"sheet":"Learn more","index":11,"n_rows":5,"n_cols":1,"rows_kept":5}
["Nice work. "]
["Thanks for viewing the chart tips! Now take a look at these other links to help make you even more productive:"]
["Learn more about charts\nTake a look at this article for more details on creating charts."]
["Change your default chart type\nSee this topic about changing your default chart type for ALT+F1."]
["Community\nAsk questions and connect with other Excel fans."]