{"text_format":"3","workbook":"xlsx","n_sheets":27,"sheets":["Start","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","Learn more"],"not_rendered":{"charts":29,"images":18,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["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."]
["Going beyond pie charts"]
["Need to master pie charts? This tutorial will show you the ropes. \nHowever, sometimes pie charts can have problems. So we'll show\nyou how to solve those problems with other kinds of charts. "]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":104,"n_cols":3,"rows_kept":104}
["First thing's first: When should you use a pie chart? When you need to show parts (slices) that make up a whole. "]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly, $500, and Sally $200."]
["EXPERT TIP: This pie chart has only four slices. This is ideal because it gives you quick idea of how much each sales rep contributed to sales in April 2019."]
[" If you end up with more than four slices, another chart is probably best. (More on that later.)"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":94}
[null,"Salesperson","April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"2","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
["Before you create a pie chart, make sure your data is set up correctly: Create one column of categories, and one column of values."]
["Cells B9 through C12 contains Data. There are two columns: Categories and Values. The Categories column contains the values Brian, Dave, Kelly, and Sally. The Values column contains the values $1,100, $650, $500, and $200."]
["A picture of a pie chart sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200."]
["IMPORTANT DETAIL: Notice how the number of categories determines how many slices end up in the pie chart."]
["Also notice how Excel automatically calculates the percentages of each value behind the scenes. It then sizes the slices for you. No need for you to write any formulas!"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"3","index":3,"n_rows":16,"n_cols":3,"rows_kept":16}
["Another thing to do beforehand: Type a title above the values. This will end up as the title of the pie chart itself, so make it descriptive."]
["Cells B12 through C16 contains Data. The Data has a descriptive title: April 2019 Sales."]
["A picture of a pie chart that has a descriptive title: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"4","index":4,"n_rows":16,"n_cols":3,"rows_kept":16}
["One last thing to do before creating a chart: Sort the values from largest to smallest. This will make the slices easily readable in a clockwise direction. "]
["Cells B13 through C16 contains data. The data is titled: April 2019 Sales. There are four rows: Brian $1,100, Dave $650, Kelly $500, and Sally $200. An arrow pointing towards the data has a label that says, \"This column is sorted from largest to smallest...\""]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200. An arrow pointing towards the pie chart has a label that says, \"...the largest slice will start at the \"12 o'clock\" position, and the rest of the slices will follow in a clockwise direction.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"5","index":5,"n_rows":15,"n_cols":3,"rows_kept":15}
["Practice"]
["1. In cell C11, type a descriptive title like \"April 2019 Sales.\""]
["2. Now right-click any of the numbers and choose Sort > Sort Largest to Smallest (ALT+A+SD)."]
["3. Select one of the cells with numbers. Then on the Insert tab (ALT+N), click the Pie button (Q), and select the first 2D pie option."]
["4. Move the pie to a better position, and then at the top of the window, click the Chart Design tab (ALT+JC). Then click Change Colors (H) to pick a different set of colors for the chart."]
["Cells B12 through C15 contains Data. The Data has four rows: Kelly $500, Dave $650, Brian $1,100, and Sally $200."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"6","index":6,"n_rows":104,"n_cols":3,"rows_kept":104}
["You made a pie chart, that's great! But we can make it even better. One way to do that is to directly label the slices using data labels. Read how to do this under \"Try this\", below. "]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices. Below the pie chart lists four names: Brian, Dave, Kelly, and Sally."]
["TRY THIS: Right-click any slice, and choose Add Data Labels (ALT+JC+D). Now you can see the exact values for each slice."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":95}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"7","index":7,"n_rows":104,"n_cols":3,"rows_kept":104}
["Let's make the data labels even better. Data labels can show values, as shown below. But they can also show each category, which makes a legend unnecessary."]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: $1,100, $650, $500, and $200. Below the pie chart lists four names: Brian, Dave, Kelly, and Sally."]
["TRY THIS: Right-click a slice and choose Format Data Labels. In the pane that appears, select the Category name checkbox. And below that, set the Separator to (New line). Now right-click the legend and delete it, since it's not needed anymore."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":95}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"8","index":8,"n_rows":104,"n_cols":3,"rows_kept":104}
["Data labels can also show percentages. This is handy when you already know the total, and you just need to see the percentage for each slice. Try it out below!"]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200."]
["TRY THIS: Right-click a slice and choose Format Data Labels. In the pane that appears, click Percentage. Since adding the percentages makes the labels crowded, go ahead uncheck the Value checkbox."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":95}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"9","index":9,"n_rows":104,"n_cols":3,"rows_kept":104}
["Here's a tip: Use color to emphasize and de-emphasize slices. This is useful when the chart is on a PowerPoint slide, and you need the audience to focus on one of the slices. "]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200. All the slices are de-emphasized by the color gray except for the slice, Dave $650, which is emphasized by the color yellow."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":96}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"10","index":10,"n_rows":104,"n_cols":3,"rows_kept":104}
["Practice using color to emphasize and de-emphasize slices "]
["1. Right-click one of the slices below, and choose Format Data Series. Then, in the Format Data Series pane, click the Paint bucket icon."]
["2. In the Format Data Series pane, under Fill, and choose a gray for the Color option. "]
["3. Now select a slice. To do this, click an empty area of a slice, but don't select a data label. You'll know you've selected a slice when three handles appear on the corners of the slice."]
["4. Right-click the selected slice, and choose Format Data Point. In the Format Data Point pane, click the Fill icon, and then change the Color option to an orange, green, or some color that stands out.  "]
["A picture of a pie chart titled: April 2019 Sales. The pie chart is sliced into four slices: Brian $1,100, Dave $650, Kelly $500, and Sally $200. Each slice is color coded to emphasize and de-emphasize the slices."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":92}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"11","index":11,"n_rows":104,"n_cols":3,"rows_kept":104}
["Here's another tip: Consider creating a doughnut chart. Why? Some people find the arcs of a doughnut easier to compare than the slices of a pie chart."]
["A picture of a pie chart sliced into four slices: $1,100, $650, $500, and $200."]
["A picture of a doughnut chart sliced into four slices: $1,100, $650, $500, and $200."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":95}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]

{"sheet":"12","index":12,"n_rows":104,"n_cols":3,"rows_kept":104}
["Practice making a doughnut chart"]
["1. Click inside the data below. Then on the Insert tab (ALT+N), click the Pie button (Q), and then select the Doughnut option."]
["2. Move the chart if you need to. Then right-click any arc, and choose Format Data Series. For Doughnut Hole Size, type in 50%."]
["3. Now right-click any arc, and choose Add Data Labels. Then right-click an arc and choose Format Data Labels. Select the Category Name checkbox. For Separator, choose (New Line). Delete the legend."]
["4. We made the total circle below. Now something for you to do: Right-click it and choose Bring to Front (ALT+P+AF). Then drag it inside the doughnut chart. "]
["Cells B17 through C21 contains Data. The Data is titled: April 2019 Sales. There are four rows of data: Brian $1,100, Dave $650, Kelly $500, and Sally $200."]
["A picture of a yellow total circle with a description inside: Total: $2,450"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":8}
[null,null,"April 2019 Sales"]
[null,"Brian",{"v":1100,"d":"$1,100"}]
[null,"Dave",{"v":650,"d":"$650"}]
[null,"Kelly",{"v":500,"d":"$500"}]
[null,"Sally",{"v":200,"d":"$200"}]
{"$rows_empty":78}
[null,null,"My 2019 Expenses"]
[null,"Housing",{"v":2500,"d":"$2,500"}]
[null,"Transportation",{"v":1200,"d":"$1,200"}]
[null,"Food",{"v":800,"d":"$800"}]
[null,"Clothing",{"v":200,"d":"$200"}]

{"sheet":"13","index":13,"n_rows":125,"n_cols":11,"rows_kept":125}
["Sometimes, pie charts can have problems. Here are just a few examples. In the next few sheets, we'll explain these problems and how to solve them. "]
["A picture of a color coded 3D pie chart. This pie chart is sliced into four slices: Brian, Dave, Kelly, and Sally."]
["A picture of a color coded pie chart sliced into fourteen slices."]
[" A list of the fourteen titled sections are below the pie chart: North campus B2B Joe, North campus B2B Moe, North campus B2C Mindy, South campus B2B Tim, South campus B2B Zane, South campus B2C Jeff, East campus B2B Lars, North campus B2B Ely, North campus B2C Jill, North campus B2C Jason, South campus B2B Sal, South campus B2C Greg, South campus B2C Mike, East campus B2B Abby."]
["A picture of a color coded pie chart sliced into nine slices: Joe $2,200, Ely $800, Moe $600, Jill $500, Jason $300, Tim $200, Sal $200, Zane $200, Greg $100."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":92}
[null,"Data for 3D chart",null,null,"Data for many slices",null,null,"Hierarchical data"]
[]
[null,null,"April 2019 Sales",null,null,"May 2020 Sales",null,"Campus","Type","Office","Sales"]
[null,"Brian",800,null,"Joe",{"v":2200,"d":"$2,200"},null,"North campus","B2B","Joe",300]
[null,"Dave",700,null,"Ely",{"v":800,"d":"$800"},{"$nulls":3},"Ely",200]
[null,"Kelly",500,null,"Moe",{"v":600,"d":"$600"},{"$nulls":3},"Moe",400]
[null,"Sally",200,null,"Jill",{"v":500,"d":"$500"},null,null,"B2C","Jill",100]
[{"$nulls":4},"Jason",{"v":300,"d":"$300"},{"$nulls":3},"Mindy",300]
[{"$nulls":4},"Tim",{"v":200,"d":"$200"},{"$nulls":3},"Jason",500]
[{"$nulls":4},"Sal",{"v":200,"d":"$200"},null,"South campus","B2B","Tim",600]
[{"$nulls":4},"Zane",{"v":200,"d":"$200"},{"$nulls":3},"Sal",400]
[{"$nulls":4},"Greg",{"v":100,"d":"$100"},{"$nulls":3},"Zane",200]
[{"$nulls":8},"B2C","Greg",400]
[{"$nulls":9},"Jeff",200]
[{"$nulls":9},"Mike",600]
[{"$nulls":7},"East campus","B2B","Lars",1000]
[{"$nulls":9},"Abby",300]
[{"$nulls":9},"Carly",200]
[{"$nulls":8},"B2C","Daren",400]
[{"$nulls":9},"Karl",100]
[{"$nulls":9},"Joseph",600]
[{"$nulls":7},"West campus","B2B","Dave",600]
[{"$nulls":9},"Hal",100]
[{"$nulls":9},"Oliver",1000]
[{"$nulls":8},"B2C","Phil",200]
[{"$nulls":9},"Quinn",900]
[{"$nulls":9},"Coco",600]

{"sheet":"14","index":14,"n_rows":104,"n_cols":3,"rows_kept":104}
["First problem to be aware of: 3D pie charts can distort slices, making the front slices look larger than they really are. In general, we don't recommend using 3D pie charts."]
["A picture of a 3D, color coded pie chart sliced into four slices: Joy, Ivy, Dan, and Ben. "]
["An arrow pointing towards the pie chart has a label that says, \"Ivy's slice looks pretty big. Is she truly the leader in sales? Or does her slice just look like the biggest?...\""]
["A picture of a 3D, color coded pie chart sliced into four slices: Joy, Ivy, Dan, and Ben."]
["However, this pie chart has added data labels: Joy $800, Ivy $700, Dan $500, and Ben $200. These labels show that Joy's slice is truly the largest. If you use 2D pie charts, you can avoid the distortion problem."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":93}
[null,null,"April 2019 Sales"]
[null,"Joy",{"v":800,"d":"$800"}]
[null,"Ivy",{"v":700,"d":"$700"}]
[null,"Dan",{"v":500,"d":"$500"}]
[null,"Ben",{"v":200,"d":"$200"}]

{"sheet":"15","index":15,"n_rows":110,"n_cols":3,"rows_kept":110}
["Too many slices is a common problem with pie charts. If you're ever in this situation, consider changing to another chart like a column chart. "]
["A picture of a pie chart titled: May 2020 Sales. This pie chart is color coded and sliced into ten slices: Joe $2,200, Ely $800, Moe $600, Jill $500, Mindy $300, Jason $300, Tim $200, Sal $200, Zane $200, Greg $100."]
["An arrow pointing towards a pie chart that says, \"Problem: This pie chart has many slices, and it's hard to compare them.\" The slices are labeled, however, the labels and the slices are too close together which makes it hard to compare the data."]
["A picture of a column chart titled: May 2020 Sales. The column chart has ten columns: Joe $2,200, Ely $800, Moe $600, Jill $500, Mindy $300, Jason $300, Tim $200, Sal $200, Zane $200, Greg $100. An arrow pointing towards the column chart has a label that says, \"Solution: Use a column chart, and comparing the values is much easier.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":94}
[null,null,"May 2020 Sales"]
[null,"Joe",{"v":2200,"d":"$2,200"}]
[null,"Ely",{"v":800,"d":"$800"}]
[null,"Moe",{"v":600,"d":"$600"}]
[null,"Jill",{"v":500,"d":"$500"}]
[null,"Mindy",{"v":300,"d":"$300"}]
[null,"Jason",{"v":300,"d":"$300"}]
[null,"Tim",{"v":200,"d":"$200"}]
[null,"Sal",{"v":200,"d":"$200"}]
[null,"Zane",{"v":200,"d":"$200"}]
[null,"Greg",{"v":100,"d":"$100"}]

{"sheet":"16","index":16,"n_rows":110,"n_cols":3,"rows_kept":110}
["Practice changing from a pie chart, to a column chart."]
["1. Click the border of the chart below to select it. Then select the Chart Design tab at the top of the window (ALT+JC), select Change Chart Type (C)."]
["2. Select Column on the left list menu, and then confirm selection by selecting OK or pressing the enter key."]
["3. This column chart works pretty well, but we don't need the vertical and horizontal axes, since we already have data labels on the columns…"]
["4. Select the pie chart, and go to the Chart Design tab (ALT+JC). Toggle vertical axis with the command (A+X+V) and (A+X+H) to toggle the horizontal axis."]
["A picture of a pie chart titled: May 2020 Sales. The pie chart is color coded and is sliced into ten slices: Joe $2,200, Ely $800, Moe $600, Jill $500, Mindy $300, Jason $300, Tim $200, Sal $200, Zane $200, Greg $100."]
["However, there are too many slices. The labels and the slices are too close together which makes it hard to compare the data."]
[]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":90}
[null,null,"May 2020 Sales"]
[null,"Joe",{"v":2200,"d":"$2,200"}]
[null,"Ely",{"v":800,"d":"$800"}]
[null,"Moe",{"v":600,"d":"$600"}]
[null,"Jill",{"v":500,"d":"$500"}]
[null,"Mindy",{"v":300,"d":"$300"}]
[null,"Jason",{"v":300,"d":"$300"}]
[null,"Tim",{"v":200,"d":"$200"}]
[null,"Sal",{"v":200,"d":"$200"}]
[null,"Zane",{"v":200,"d":"$200"}]
[null,"Greg",{"v":100,"d":"$100"}]

{"sheet":"17","index":17,"n_rows":105,"n_cols":3,"rows_kept":105}
["Another problem: Pie slices are too similar. When this happens, people might start looking around the room wondering, \"What's the key takeaway here?\""]
["A pie chart titled: June 2020 Sales. This pie chart is color coded and is sliced into five slices: Moe, Mind, Jill, Joe, and Ely."]
["An arrow pointing towards the pie chart has a label that says, \"Problem: these slices are so similar, it's hard to identify anything useful. For example: Who's the leading sales rep?\""]
["A bar chart titled: June 2020 Sales. The bar chart has five bars: Ely $400, Joe $450, Jill $500, Mindy $550, and Moe, $600."]
["An arrow pointing towards the bar chart has a label that says, \"Solution: Change the pie chart to another chart like a bar chart. That way you can see who's in the lead now: Moe!\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":93}
[null,null,"June 2020 Sales"]
[null,"Moe",{"v":600,"d":"$600"}]
[null,"Mindy",{"v":550,"d":"$550"}]
[null,"Jill",{"v":500,"d":"$500"}]
[null,"Joe",{"v":450,"d":"$450"}]
[null,"Ely",{"v":400,"d":"$400"}]

{"sheet":"18","index":18,"n_rows":105,"n_cols":3,"rows_kept":105}
["Practice changing from a pie chart, to a bar chart"]
["1. Select the chart below. Then on the Chart Design tab (ALT+JC), selet Change Chart Type (A)."]
["2. Select Bar chart from the menu list, and select ok or use the enter key to confirm."]
["3. This bar needs some clean up. With the bar graph selected, go to Chart Design (ALT+JC) and toggle data labels (A+D+N)."]
["4. Now toggle the horizontal axis on the bottom of the chart (ALT+JC, then A+X+H). (The horizontal axis is the one that starts with 0 and ends with 700). "]
["A picture of a color coded pie chart titled: June 2020 Sales. This pie chart is color coded and is sliced into five slices: Moe, Mindy, Jill, Joe, and Ely."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":92}
[null,null,"June 2020 Sales"]
[null,"Moe",{"v":600,"d":"$600"}]
[null,"Mindy",{"v":550,"d":"$550"}]
[null,"Jill",{"v":500,"d":"$500"}]
[null,"Joe",{"v":450,"d":"$450"}]
[null,"Ely",{"v":400,"d":"$400"}]

{"sheet":"19","index":19,"n_rows":15,"n_cols":5,"rows_kept":15}
["Here's another issue: Pie chart overload. Multiple pies on the same sheet can work okay, but it's pretty difficult for some people to compare all the pies and slices. "]
["Cells B12 through E15 contains Data. The data has three columns: 2018, 2019, and 2020. The data also has three rows: Roses, Tulips, and Irises. "]
["A picture of a pie chart titled: 2018. The pie chart is sliced into three slices: Tulips 60%, Irises 33%, and Roses 7%."]
["A picture of a pie chart titled: 2019. The pie chart is sliced into three slices: Tulips 32%, Irises 42%, and Roses 25%."]
["A picture of a pie chart titled: 2020. The pie chart is sliced into three slices: Tulips 27%, Irises 20%, and Roses 54%."]
["An arrow pointing toward the three different pie charts has a label that says, \"…and we made three pie charts, that visualize each year. But it's hard to compare each and every slice. A better choice is to use a column chart, which we'll explain on the next sheet...\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[null,null,2018,2019,2020]
[null,"Roses",{"v":0.07,"d":"7%"},{"v":0.2542372881355932,"d":"25%"},{"v":0.5357142857142857,"d":"54%"}]
[null,"Tulips",{"v":0.6,"d":"60%"},{"v":0.3220338983050847,"d":"32%"},{"v":0.26785714285714285,"d":"27%"}]
[null,"Irises",{"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}
["Practice using a 100% Stacked Column Chart"]
["1. Select any cell inside the data below (B14:E16), and then on the Insert tab (ALT+N), select the insert column or bar chart option (C1)."]
["2.Then under 2D Column, select stacked column."]
["3. Move the chart into a better position if you need to. Then, with the bar graph selected, go to Chart Design (ALT+JC) and toggle data labels (A+D+N)."]
["4. To set the chart title, go to Chart Design (ALT+JC), add chart element (A), Chart title (C), and select (A) for title above chart. Now you are focused on the title cell and can type, Flower Sales."]
["Cells B13 through E16 contains data. The data has three columns: 2018, 2019, and 2020. The sata also has three rows: Roses, Tulips, and Irises. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,null,2018,2019,2020]
[null,"Roses",{"v":0.07,"d":"7%"},{"v":0.2542372881355932,"d":"25%"},{"v":0.5357142857142857,"d":"54%"}]
[null,"Tulips",{"v":0.6,"d":"60%"},{"v":0.3220338983050847,"d":"32%"},{"v":0.26785714285714285,"d":"27%"}]
[null,"Irises",{"v":0.3333333333333333,"d":"33%"},{"v":0.423728813559322,"d":"42%"},{"v":0.19642857142857142,"d":"20%"}]
{"$rows_empty":83}
[null,null,"2019 Sales"]
[null,"Jo",{"v":310,"d":"$310"}]
[null,"Bill",{"v":305,"d":"$305"}]
[null,"Cyril",{"v":302,"d":"$302"}]
[null,"Tim",{"v":300,"d":"$300"}]
[null,"Frank",{"v":299,"d":"$299"}]
[null,"Emma",{"v":290,"d":"$290"}]
[null,"Jeff",{"v":286,"d":"$286"}]
[null,"Eli",{"v":268,"d":"$268"}]
[null,"Kim",{"v":260,"d":"$260"}]

{"sheet":"21","index":21,"n_rows":36,"n_cols":5,"rows_kept":36}
["Another problem: You have hierarchical data. A pie chart can try to visualize this, but it will stay firm to its roots, and only use one column of categories and one column of values. "]
["Cells B12 through E36 contains data. The data has four columns: Campus, Type, Rep, and Week 1 Sales. The data also has 25 rows, labeled with different sections."]
["There is a bracket grouping cells B12 through D12 that says, \"In this data, it's almost like we have three category columns…\""]
["There is a bracket grouping cell E12 with a label that says, \"...and one value column.\""]
["A picture of a color coded pie chart titled: Week 1 Sales. This pie chart is sliced into twenty-four slices. The labels for all the slices are listed below the pie chart."]
["An arrow pointing towards the picture of the pie chart has a label that says, \"Excel tries to make a pie chart with this data, but that's a lot of slices and an enormous legend! On the next sheet, you'll see how a sunburst chart works better for this data.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[null,"Campus","Type","Rep","Week 1 Sales"]
[null,"North campus","B2B","Joe",{"v":30,"d":"$30"}]
[{"$nulls":3},"Eli",{"v":20,"d":"$20"}]
[{"$nulls":3},"Moe",{"v":40,"d":"$40"}]
[null,null,"B2C","Jan",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jim",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jay",{"v":50,"d":"$50"}]
[null,"South campus","B2B","Tim",{"v":60,"d":"$60"}]
[{"$nulls":3},"Sal",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zed",{"v":20,"d":"$20"}]
[null,null,"B2C","Guy",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zeb",{"v":20,"d":"$20"}]
[{"$nulls":3},"Cat",{"v":60,"d":"$60"}]
[null,"East campus","B2B","Taj",{"v":100,"d":"$100"}]
[{"$nulls":3},"Liv",{"v":30,"d":"$30"}]
[{"$nulls":3},"Lex",{"v":20,"d":"$20"}]
[null,null,"B2C","Abe",{"v":40,"d":"$40"}]
[{"$nulls":3},"Les",{"v":30,"d":"$30"}]
[{"$nulls":3},"Ann",{"v":60,"d":"$60"}]
[null,"West campus","B2B","Ivy",{"v":60,"d":"$60"}]
[{"$nulls":3},"Hal",{"v":30,"d":"$30"}]
[{"$nulls":3},"Joy",{"v":100,"d":"$100"}]
[null,null,"B2C","Liz",{"v":30,"d":"$30"}]
[{"$nulls":3},"Tia",{"v":120,"d":"$120"}]
[{"$nulls":3},"Zoe",{"v":60,"d":"$60"}]

{"sheet":"22","index":22,"n_rows":36,"n_cols":5,"rows_kept":36}
["A sunburst chart can visualize hierarchical data. It's like the outside ring is a doughnut chart with different sized arcs, and the inner rings visualize the underlying hierarchy."]
["Cells B12 through E36 contains data. The data has four columns: Campus, Type, Rep, and Week 1 Sales. The data also has 25 rows, labeled with different sections."]
["A bracket grouping cells B12 through D12 has a label that says, \"This sunburst chart uses these three columns for the three inner rings…\""]
["A bracket grouping cell E12 has a label that says, \"...and uses this column for the outer ring.\""]
["A picture of a doughnut chart titled: Week 1 Sales. The doughnut chart is color coded and has sliced arcs with the data labeled inside. An arrow pointing towards the doughnut chart has a label that says, \"Here's an example of how to read this chart: \"In the West campus, of all B2C sales, Tia is the biggest seller follow by Zoe and Liz.\"\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Campus","Type","Rep","Week 1 Sales"]
[null,"North campus","B2B","Joe",{"v":30,"d":"$30"}]
[{"$nulls":3},"Eli",{"v":20,"d":"$20"}]
[{"$nulls":3},"Moe",{"v":40,"d":"$40"}]
[null,null,"B2C","Jan",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jim",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jay",{"v":50,"d":"$50"}]
[null,"South campus","B2B","Tim",{"v":60,"d":"$60"}]
[{"$nulls":3},"Sal",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zed",{"v":20,"d":"$20"}]
[null,null,"B2C","Guy",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zeb",{"v":20,"d":"$20"}]
[{"$nulls":3},"Cat",{"v":60,"d":"$60"}]
[null,"East campus","B2B","Taj",{"v":100,"d":"$100"}]
[{"$nulls":3},"Liv",{"v":30,"d":"$30"}]
[{"$nulls":3},"Lex",{"v":20,"d":"$20"}]
[null,null,"B2C","Abe",{"v":40,"d":"$40"}]
[{"$nulls":3},"Les",{"v":30,"d":"$30"}]
[{"$nulls":3},"Ann",{"v":60,"d":"$60"}]
[null,"West campus","B2B","Ivy",{"v":60,"d":"$60"}]
[{"$nulls":3},"Hal",{"v":30,"d":"$30"}]
[{"$nulls":3},"Joy",{"v":100,"d":"$100"}]
[null,null,"B2C","Liz",{"v":30,"d":"$30"}]
[{"$nulls":3},"Tia",{"v":120,"d":"$120"}]
[{"$nulls":3},"Zoe",{"v":60,"d":"$60"}]

{"sheet":"23","index":23,"n_rows":37,"n_cols":5,"rows_kept":37}
["Practice changing from a pie chart, to a sunburst chart"]
["1. Select the pie chart below. Then on the Chart Design tab (ALT+C), select Change Chart Type (C)."]
["2. On the left menu list select Sunburst, and select ok or press the enter key to confirm. When the chart has changed, select the chart, and toggle Data Labels (ALT+JC, then A+D). "]
["3. To format data labels we need to go back to the add chart element option (ALT+JC+A). Then (D+M) for more data label options. Select both the Category Name and Value checkbox."]
["4. Do step 1 again, but this time change to the Treemap chart. Now each campus has a color, and the boxes represent the sales for each rep."]
["Cells B13 through E37 contains data. The data has four columns: Campus, Type, Rep, and Week 1 Sales. The data also has 25 rows, labeled with different sections."]
["A picture of a color coded pie chart titled: Week 1 Sales. This pie chart is sliced into twenty-four slices. The labels for all the slices are listed below the pie chart."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[null,"Campus","Type","Rep","Week 1 Sales"]
[null,"North campus","B2B","Joe",{"v":30,"d":"$30"}]
[{"$nulls":3},"Eli",{"v":20,"d":"$20"}]
[{"$nulls":3},"Moe",{"v":40,"d":"$40"}]
[null,null,"B2C","Jan",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jim",{"v":30,"d":"$30"}]
[{"$nulls":3},"Jay",{"v":50,"d":"$50"}]
[null,"South campus","B2B","Tim",{"v":60,"d":"$60"}]
[{"$nulls":3},"Sal",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zed",{"v":20,"d":"$20"}]
[null,null,"B2C","Guy",{"v":40,"d":"$40"}]
[{"$nulls":3},"Zeb",{"v":20,"d":"$20"}]
[{"$nulls":3},"Cat",{"v":60,"d":"$60"}]
[null,"East campus","B2B","Taj",{"v":100,"d":"$100"}]
[{"$nulls":3},"Liv",{"v":30,"d":"$30"}]
[{"$nulls":3},"Lex",{"v":20,"d":"$20"}]
[null,null,"B2C","Abe",{"v":40,"d":"$40"}]
[{"$nulls":3},"Les",{"v":30,"d":"$30"}]
[{"$nulls":3},"Ann",{"v":60,"d":"$60"}]
[null,"West campus","B2B","Ivy",{"v":60,"d":"$60"}]
[{"$nulls":3},"Hal",{"v":30,"d":"$30"}]
[{"$nulls":3},"Joy",{"v":100,"d":"$100"}]
[null,null,"B2C","Liz",{"v":30,"d":"$30"}]
[{"$nulls":3},"Tia",{"v":120,"d":"$120"}]
[{"$nulls":3},"Zoe",{"v":60,"d":"$60"}]

{"sheet":"24","index":24,"n_rows":21,"n_cols":12,"rows_kept":21}
["One last thing before you go: Sometimes you might have data that isn't summarized yet. In these cases, you need to create a special kind of chart: A PivotChart. "]
["Cells B12 through D21 contains data. There are three columns: Month, Rep, and Sales. There are nine rows the contains the data information."]
["An arrow pointing towards cells B12 through D21 has a label that says, \"This data is not summarized yet. We really need each rep's sales summed up, and each sum represented in a pie chart... \""]
["A picture of a color coded pie chart titled: Total. The pie chart is sliced into three slices: Eric 120, Joe 135, and Milly 70."]
["An arrow is pointing towards the pie chart with a label that says, \"...To do that, we made a PivotChart. But how did it summarize each rep's sales? \""]
["Cells K12 through L16 contains data. The data has two columns: Row Labels (with a drop down menu) and Sum of Sales. The data also has five rows that consists of the names: Eric, Joe, Milly, and a Gran Total of the Sum of Sales."]
["An arrow pointing towards the data has a label that says, \"With every PivotChart, comes a PIvotTable, which sums up the sales for each rep.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,"Month","Rep","Sales",{"$nulls":6},"Row Labels","Sum of Sales"]
[null,"Jan","Joe",{"v":60,"d":"$60"},{"$nulls":6},"Eric",120]
[null,"Jan","Eric",{"v":20,"d":"$20"},{"$nulls":6},"Joe",135]
[null,"Jan","Milly",{"v":30,"d":"$30"},{"$nulls":6},"Milly",70]
[null,"Feb","Joe",{"v":15,"d":"$15"},{"$nulls":6},"Grand Total",325]
[null,"Feb","Eric",{"v":50,"d":"$50"}]
[null,"Feb","Milly",{"v":30,"d":"$30"}]
[null,"Mar","Joe",{"v":60,"d":"$60"}]
[null,"Mar","Eric",{"v":50,"d":"$50"}]
[null,"Mar","Milly",{"v":10,"d":"$10"}]

{"sheet":"25","index":25,"n_rows":27,"n_cols":4,"rows_kept":27}
["Practice creating a PivotChart"]
["1. Select any cell in the data below (B18:D27), and then on the Insert tab (ALT+N), select PivotChart (SZ+C)."]
["2. In the Create PivotChart dialog box, select Existing Worksheet, and in the Location box,  type F18. Select ok press the enter key to confirm."]
["3. In the PivotTable Fields pan, select the checkbox items for Rep and Sales. Then move the chart into a better position."]
["4. Select the pivot chart. Then go to the Design tab (ALT+JC), select Change Chart Type (C), and choose the 2D pie chart option."]
["When the pie chart appears, select the chart again and toggle Data Labels (ALT+JC, then A+D)."]
["Cells B18 through D27 contains data. The data has three columns: Month, rep, and Sales. The data also has ten rows that consists of the data information."]
{"$rows_empty":10}
[null,"Month","Rep","Sales"]
[null,"Jan","Joe",{"v":60,"d":"$60"}]
[null,"Jan","Eric",{"v":20,"d":"$20"}]
[null,"Jan","Milly",{"v":30,"d":"$30"}]
[null,"Feb","Joe",{"v":15,"d":"$15"}]
[null,"Feb","Eric",{"v":50,"d":"$50"}]
[null,"Feb","Milly",{"v":30,"d":"$30"}]
[null,"Mar","Joe",{"v":60,"d":"$60"}]
[null,"Mar","Eric",{"v":50,"d":"$50"}]
[null,"Mar","Milly",{"v":10,"d":"$10"}]

{"sheet":"Learn more","index":26,"n_rows":6,"n_cols":1,"rows_kept":6}
["You made some great pies! Good job."]
["Now check out these other links to help make you even more productive:"]
["Learn more: Take a look at this article for more details on creating a pie chart."]
["Try this shortcut: You can automatically create charts with this feature."]
["Videos: Learn by watching. These videos guide you through it all."]
["Community: Ask questions and connect with other Excel fans"]