{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Index","Demo","Excel understanding","Embedded chart","Full page chart","Simple work","Manage empty cell & hidden col","Working any element","Using the funnel button","Rain-Europe","VIH-Switzerland 1","Average Swiss income","World resources","Working on the axis","Working on the axis - Answers","Excel limits","VIH-Switzerland 2","Tax","Secondary axis","Error bars","Error bars - custom","Trend line","Trend line and equation","Bars","Area","Scatter","Swiss Population","Fertility rate","Pie special","Columns and negative values","Radar","Stock","Bubbles","Scatter-bubble for 2 dimensions","Tableau de bord","Graphique probabilité impact","Sparkline","Drawn shapes","Drawn shapes - To do","SmartArt","SmartArt - To do"],"not_rendered":{"charts":68,"images":27,"macros":1,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[{"sheet":"Full page chart","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Contents"]
["Standard chart"]
[null,"Demo and explanations"]
[null,"Rain in Europe"]
[null,"VIH in Switzerland 1"]
[null,"Average Swiss income"]
[null,"Working on the axis"]
["Help Excel when automatic chart building isn't satisfactory"]
[null,"Excel limits"]
[null,"VIH in Switzerland 2"]
[null,"Tax"]
["Special"]
[null,"Secondary axis"]
[null,"Error bars"]
[null,"Error bars 2"]
[null,"Trend line"]
[null,"Trend line 2"]
["Examples of less common charts"]
[null,"Bars"]
[null,"Area"]
[null,"Scatter"]
[null,"Swiss population"]
[null,"Fertility rate   (* with labels pointing to free cells)"]
[null,"Pie - special"]
[null,"Column and negative values"]
[null,"Radar"]
[null,"Stock"]
[null,"Bubbles"]
[null,"Scatter-bubble"]
[null,"Special bubble : 3 variables for each series"]
[]
["New 2010 : Sparkline charts"]
[null,"Example"]
["Graphic tools"]
[null,"Drawn shapes"]
[null,"SmarArt charts"]

{"sheet":"Demo","index":1,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["\u008c","How Excel understands your selection"]
[]
["\u008d","A chart can be embedded (by default) or full page"]
[]
["Sales","2020-01-01","2020-02-01","2020-03-01",null,"Sales","Switzerland","France","Italy","Spain","Portugal","Belgium",null,"Sales","Switzerland","France","Italy"]
["Product 1",16894,18854,23000,null,"Product 1",16894,18854,23000,24000,18000,21000,null,"Produtct 1",16894,18854,23000]
["Product 2",20210,19632,25784,null,"Product 2",20210,19632,25784,19865,21563,24789,null,"Produtct 2",20210,19632,25784]
["Product 3",18052,21135,22458,null,"Product 3",23000,21135,22458,23546,17896,21569,null,"Produtct 3",23000,21135,22458]
["Product 4",16000,20456,24182,null,"Product 4",19580,20456,24182,19000,22569,18963,null,"Produtct 4",19580,20456,24182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 5",24000,18000,21000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 7",23546,17896,21569]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 8",19000,22569,18963]
[]
["\u008e","First actions on the created charts"]
[]
[]
[null,"Special : how to understand empty cells or hidden columns in the source data"]
[]
[]
["\u008f","Working deeply any chart element "]
[]
[]
["\u0090","The new funnel button"]

{"sheet":"Excel understanding","index":2,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["\u008c","Excel expects DATES (real ones !) - If there are no dates, Excel assumes that the highest number of items corresponds to the future horizontal axis"]
[]
["Sales","2020-01-01","2020-02-01","2020-03-01",null,"Sales","Switzerland","France","Italy","Spain","Portugal","Belgium",null,"Sales","Switzerland","France","Italy"]
["Product 1",16894,18854,23000,null,"Product 1",16894,18854,23000,24000,18000,21000,null,"Produtct 1",16894,18854,23000]
["Product 2",20210,19632,25784,null,"Product 2",20210,19632,25784,19865,21563,24789,null,"Produtct 2",20210,19632,25784]
["Product 3",18052,21135,22458,null,"Product 3",23000,21135,22458,23546,17896,21569,null,"Produtct 3",23000,21135,22458]
["Product 4",16000,20456,24182,null,"Product 4",19580,20456,24182,19000,22569,18963,null,"Produtct 4",19580,20456,24182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 5",24000,18000,21000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 6",19865,21563,24789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 7",23546,17896,21569]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 8",19000,22569,18963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 9",21963,20147,21963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produtct 10",19635,20365,20145]

{"sheet":"Embedded chart","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["Create a chart : use the following methods : "]
[null,1,"Select the source data and use the QUICK ANALYSIS BUTTON"]
[null,2,"Select the source data and use the RECOMMENDED CHARTS button (on the INSERT Tab)"]
[null,3,"Select the source data and choose from the various types (INSERT Tab - CHARTS group)"]
[null,null,"Give a glance to the full list (Dialog box)"]
[]
[]
["\u008d","An embedded chart is like an object (picture, shape …)",null,null,null,"Use handles to size (no need to respect ratio)"]
[null,null,null,null,null,"Click and drag to move arount"]
[null,null,null,null,null,"To print data and chart : make sure your active cell is in the sheet"]
["Sales","2020-01-01","2020-02-01","2020-03-01",null,"To print the chart only : chart is active"]
["Product 1",16894,18854,23000]
["Product 2",20210,19632,25784]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
[]
[]
[null,"To turn an embedded chart into a full page one : MOVE CHART button (last button on the DESIGN Tab)"]

{"sheet":"Simple work","index":5,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[" DESIGN Tab "]
[]
["The SELECT DATA button to understand the structure of the chart (as understood by Excel)"]
["The SWITCH ROW / COLUMN button to change the understanding"]
["The MOVE CHART button to change the type of chart (embedded or full page)"]
["The CHANGE TYPE button to change the type of chart (column, line, area …)"]
["The STYLE gallery to add some \"look\" to the chart   (also the brush icon at the top right of the chart when you click on it)"]
["The QUICK LAYOUT gallery to add elements (ready made suggestions)"]
[]
["Sales","2020-01-01","2020-02-01","2020-03-01"]
["Product 1",16894,18854,23000]
["Product 2",20210,19632,25784]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sales","2020-01-01","2020-02-01","2020-03-01"]
["Product 1",16894,18854,23000]
["Product 2",20210,19632,25784]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
["Product 5",20000,21000,23000]
[]
[]
["To add a series : "]
[null,null,"If contiguous : click and drag in the source data"]
[null,null,"Simple COPY - PASTE"]
[]
[null,null,"Less comfortable but sometimes handy …"]
[null,null,"SELECT DATA button"]

{"sheet":"Manage empty cell & hidden col","index":6,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
["Empty cell",null,null,null,null,null,null,null,null,"Hidden column",null,null,"Sales","2020-01-01","2020-02-01","2020-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Product 1",16894,18854,23000]
["Sales","2020-01-01","2020-02-01","2020-03-01",null,null,null,null,null,null,null,null,"Product 2",20210,19632,25784]
["Product 1",16894,18854,23000,null,null,null,null,null,null,null,null,"Product 3",18052,21135,22458]
["Product 2",20000,null,25784,null,null,null,null,null,null,null,null,"Product 4",16000,20456,24182]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
["Product 5",20000,21000,23000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"NEW"]
[]
[]
[]
[]
[]
[]
[]
["Sales","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-01-01",20000]
["Product 1",{"$f":"VLOOKUP(B58,$F$58:$G$65,2,0)","v":20000},{"$f":"VLOOKUP(C58,$F$58:$G$65,2,0)","v":{"$error":"#N/A"}},25000,23000,"feb. 2020",30000]
[null,null,null,null,null,"2020-03-01",25000]
[null,null,null,null,null,"2020-04-01",23000,"By default : the #N/A cell is ignored and belongs to the plot",null,null,null,null,null,null,"The option is turned on : "]
[null,null,null,null,null,"2020-05-01",20000]
[null,null,null,null,null,"2020-06-01",14000]
[null,null,null,null,null,"2020-07-01",10000]
[null,null,null,null,null,"2020-08-01",8000]

{"sheet":"Working any element","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Sales for Switzerland"]
["Sales","2020-01-01","2020-02-01","2020-03-01"]
["Product 1",16894,18854,23000]
["Product 2",20210,19632,25784]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
[]
[null,null,null,null,null,"Special - easy : the chart title should point and be linked to a given cell"]
[]
[null,null,null,null,null,null,"Click on the chart title (no need to get inside with the cursor, delete any character …)"]
[null,null,null,null,null,null,"Type the = sign in the formula bar"]
[null,null,null,null,null,null,"Click the cell whose content should be the chart title"]
[null,null,null,null,null,null,"Enter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\u008f","Select and show working pane"]
[]
["Double-click on it",null,null,null,"==>","Working pane on the right automatically displayed"]
[]
["Click and FORMAT Tab - first drop-down list on the left",null,null,null,"==>","Click on FORMAT SELECTION to show the working pane"]
[]
["DESIGN Tab and ADD CHART ELEMENT button",null,null,null,"==>","From the drop-down list : ready made suggestions or full options to show the pane"]
["Click on the chart and PLUS button on the top right of it"]

{"sheet":"Using the funnel button","index":8,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Year sales",2010,2011,2012,2013,2014,2015,2016,2019,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Product 1",1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290,1300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["POINT ",null,null,"All the others are greyed out"]
["TICK OFF and then APPLY",null,null,"Only the selected ones are displayed"]

{"sheet":"Rain-Europe","index":9,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Rain average for July"]
["EUROPE","Number of days"]
["Amsterdam",10]
["Athens",1]
["Barcelona",5]
["Berlin",9]
["Dublin",13]
["Geneva",9]
["Istanbul",3]
["Lisbon",3]
["Madrid",3]
["Moscow",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienna",9]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Chart title"]
[null,null,null,null,null,null,null,null,null,null,null,"Select the title"]
[null,null,null,null,null,null,null,null,null,null,null,"Type the = sign in the formula bar"]
[null,null,null,null,null,null,null,null,null,null,null,"Click on B1"]
[null,null,null,null,null,null,null,null,null,null,null,"ENTER"]

{"sheet":"VIH-Switzerland 1","index":10,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Evolution of AIDS in Switzerland (source : \"Bulletin de l'Office Fédéral de la Santé\")"]
[]
["Year","1999-12-31","2000-01-01","2001-01-01","2002-01-01","2003-01-01","2004-01-01","2005-01-01","2006-01-01","2007-01-01","2008-01-01"]
["Casualties - Men",112,116,134,125,94,95,100,70,56,9]
["Casualties - Women",65,57,55,52,29,36,39,32,14,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Your horizontal axis could well show several occurrences of the years"]
["Simply work the axis : set that the unit should be years and not months"]

{"sheet":"Average Swiss income","index":11,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Average expenses for a Swiss Family ",null," - source OFS - year 2011"]
["Average gross income",9604]
["Insurance (social and LAMAL basic)",2646]
["Monetary transfer to other families",208]
["Other Insurance (additional health)",575]
["Consumation",5394]
["Savings",781]
["Total",{"$f":"SUM(B4:B8)","v":9604}]
[]
[]
[]
[]
[null,null,null,null,null,null,"To show connecting lines : simple click and drag the labels a bit - theY automatically follow"]
[null,null,null,null,null,null,"To move out one slice : click until only the slice is selected - then drag outside slightly"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["info 2009 - read in the 20 Minutes - november 2011",null,"(source OFS)"]
[]
["Gross monthly income",null,null,9369]
["Tax",0.12,{"$f":"$D$41*B43","v":0}]
["Social insurance (AVS …)",0.1,{"$f":"$D$41*B44","v":0}]
["Health insurance",0.05,0]
["Misceallenous",{"$f":"C46/D42","v":0.29031913758138544},{"$f":"C47-SUM(C43:C45)","v":2720}]
[null,null,2720]
[]
[null,null,null,{"$f":"D42-C47","v":6649},"Average monthly net income"]
["House and energy",0.16,{"$f":"$D$42*B50","v":1499.04}]
["Savings",0.124,{"$f":"$D$42*B51","v":1161.7560000000001}]
["Other charges",0.154,1442.826]
["Transport",7.6999999999999999E-2,721.41300000000001]
["Food and beverage",7.0000000000000007E-2,655.83]
["Leisure and culture",6.7000000000000004E-2,627.72300000000007]
["Holidays and restaurant",5.8000000000000003E-2,543.40200000000004]
[]
["39% of swiss families : more than one person works"]
["59% of swiss families : retired people"]

{"sheet":"World resources","index":12,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Energetic resources are too used",null,"déc 2009 - when N. Vanier's film Wolf was released"]
[]
["Oil",0.43099999999999999]
["Electricity",0.16700000000000001]
["Gaz",0.153]
["Renewable energy & waste",0.129]
["Coal",8.5999999999999993E-2]
["Other",3.4000000000000002E-2]
[]
["Total : 8'084 billions of tons \"petrol equivalent\""]

{"sheet":"Working on the axis","index":13,"n_rows":37,"n_cols":366,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Working on the horizontal axis"]
[]
[]
[]
[]
[]
[]
["Year sales","2020-01-01","2020-01-02","2020-01-03","2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11","2020-01-12","2020-01-13","2020-01-14","2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26","2020-01-27","2020-01-28","2020-01-29","2020-01-30","2020-01-31","2020-02-01","2020-02-02","2020-02-03","2020-02-04","2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09","2020-02-10","2020-02-11","2020-02-12","2020-02-13","2020-02-14","2020-02-15","2020-02-16","2020-02-17","2020-02-18","2020-02-19","2020-02-20","2020-02-21","2020-02-22","2020-02-23","2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28","2020-03-01","2020-03-02","2020-03-03","2020-03-04","2020-03-05","2020-03-06","2020-03-07","2020-03-08","2020-03-09","2020-03-10","2020-03-11","2020-03-12","2020-03-13","2020-03-14","2020-03-15","2020-03-16","2020-03-17","2020-03-18","2020-03-19","2020-03-20","2020-03-21","2020-03-22","2020-03-23","2020-03-24","2020-03-25","2020-03-26","2020-03-27","2020-03-28","2020-03-29","2020-03-30","2020-03-31","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04","2020-06-05","2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19","2020-06-20","2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29","2020-06-30","2020-07-01","2020-07-02","2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31","2020-08-01","2020-08-02","2020-08-03","2020-08-04","2020-08-05","2020-08-06","2020-08-07","2020-08-08","2020-08-09","2020-08-10","2020-08-11","2020-08-12","2020-08-13","2020-08-14","2020-08-15","2020-08-16","2020-08-17","2020-08-18","2020-08-19","2020-08-20","2020-08-21","2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10","2020-10-11","2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11","2020-12-12","2020-12-13","2020-12-14","2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30","2020-12-31"]
["Product 1",1000,1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290,1300,1310,1320,1330,1340,1350,1360,1370,1380,1390,1400,1410,1420,1430,1440,1450,1460,1470,1480,1490,1500,1510,1520,1530,1540,1550,1560,1570,1580,1590,1600,1610,1620,1630,1640,1650,1660,1670,1680,1690,1700,1710,1720,1730,1740,1750,1760,1770,1780,1790,1800,1810,1820,1830,1840,1850,1860,1870,1880,1890,1900,1910,1920,1930,1940,1950,1960,1970,1980,1990,2000,2010,2020,2030,2040,2050,2060,2070,2080,2090,2100,2110,2120,2130,2140,2150,2160,2170,2180,2190,2200,2210,2220,2230,2240,2250,2260,2270,2280,2290,2300,2310,2320,2330,2340,2350,2360,2370,2380,2390,2400,2410,2420,2430,2440,2450,2460,2470,2480,2490,2500,2510,2520,2530,2540,2550,2560,2570,2580,2590,2600,2610,2620,2630,2640,2650,2660,2670,2680,2690,2700,2710,2720,2730,2740,2750,2760,2770,2780,2790,2800,2810,2820,2830,2840,2850,2860,2870,2880,2890,2900,2910,2920,2930,2940,2950,2960,2970,2980,2990,3000,3010,3020,3030,3040,3050,3060,3070,3080,3090,3100,3110,3120,3130,3140,3150,3160,3170,3180,3190,3200,3210,3220,3230,3240,3250,3260,3270,3280,3290,3300,3310,3320,3330,3340,3350,3360,3370,3380,3390,3400,3410,3420,3430,3440,3450,3460,3470,3480,3490,3500,3510,3520,3530,3540,3550,3560,3570,3580,3590,3600,3610,3620,3630,3640,3650,3660,3670,3680,3690,3700,3710,3720,3730,3740,3750,3760,3770,3780,3790,3800,3810,3820,3830,3840,3850,3860,3870,3880,3890,3900,3910,3920,3930,3940,3950,3960,3970,3980,3990,4000,4010,4020,4030,4040,4050,4060,4070,4080,4090,4100,4110,4120,4130,4140,4150,4160,4170,4180,4190,4200,4210,4220,4230,4240,4250,4260,4270,4280,4290,4300,4310,4320,4330,4340,4350,4360,4370,4380,4390,4400,4410,4420,4430,4440,4450,4460,4470,4480,4490,4500,4510,4520,4530,4540,4550,4560,4570,4580,4590,4600,4610,4620,4630,4640]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Year sales",2000,2001,2002,2003,2004,2005,2006,2007,2008,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Product 1",1000,1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290]

{"sheet":"Working on the axis - Answers","index":14,"n_rows":36,"n_cols":366,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Working on the horizontal axis"]
[]
[]
[]
[]
[]
["Year sales","2020-01-01","2020-01-02","2020-01-03","2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11","2020-01-12","2020-01-13","2020-01-14","2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26","2020-01-27","2020-01-28","2020-01-29","2020-01-30","2020-01-31","2020-02-01","2020-02-02","2020-02-03","2020-02-04","2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09","2020-02-10","2020-02-11","2020-02-12","2020-02-13","2020-02-14","2020-02-15","2020-02-16","2020-02-17","2020-02-18","2020-02-19","2020-02-20","2020-02-21","2020-02-22","2020-02-23","2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28","2020-03-01","2020-03-02","2020-03-03","2020-03-04","2020-03-05","2020-03-06","2020-03-07","2020-03-08","2020-03-09","2020-03-10","2020-03-11","2020-03-12","2020-03-13","2020-03-14","2020-03-15","2020-03-16","2020-03-17","2020-03-18","2020-03-19","2020-03-20","2020-03-21","2020-03-22","2020-03-23","2020-03-24","2020-03-25","2020-03-26","2020-03-27","2020-03-28","2020-03-29","2020-03-30","2020-03-31","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04","2020-06-05","2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19","2020-06-20","2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29","2020-06-30","2020-07-01","2020-07-02","2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31","2020-08-01","2020-08-02","2020-08-03","2020-08-04","2020-08-05","2020-08-06","2020-08-07","2020-08-08","2020-08-09","2020-08-10","2020-08-11","2020-08-12","2020-08-13","2020-08-14","2020-08-15","2020-08-16","2020-08-17","2020-08-18","2020-08-19","2020-08-20","2020-08-21","2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10","2020-10-11","2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11","2020-12-12","2020-12-13","2020-12-14","2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30","2020-12-31"]
["Product 1",1000,1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290,1300,1310,1320,1330,1340,1350,1360,1370,1380,1390,1400,1410,1420,1430,1440,1450,1460,1470,1480,1490,1500,1510,1520,1530,1540,1550,1560,1570,1580,1590,1600,1610,1620,1630,1640,1650,1660,1670,1680,1690,1700,1710,1720,1730,1740,1750,1760,1770,1780,1790,1800,1810,1820,1830,1840,1850,1860,1870,1880,1890,1900,1910,1920,1930,1940,1950,1960,1970,1980,1990,2000,2010,2020,2030,2040,2050,2060,2070,2080,2090,2100,2110,2120,2130,2140,2150,2160,2170,2180,2190,2200,2210,2220,2230,2240,2250,2260,2270,2280,2290,2300,2310,2320,2330,2340,2350,2360,2370,2380,2390,2400,2410,2420,2430,2440,2450,2460,2470,2480,2490,2500,2510,2520,2530,2540,2550,2560,2570,2580,2590,2600,2610,2620,2630,2640,2650,2660,2670,2680,2690,2700,2710,2720,2730,2740,2750,2760,2770,2780,2790,2800,2810,2820,2830,2840,2850,2860,2870,2880,2890,2900,2910,2920,2930,2940,2950,2960,2970,2980,2990,3000,3010,3020,3030,3040,3050,3060,3070,3080,3090,3100,3110,3120,3130,3140,3150,3160,3170,3180,3190,3200,3210,3220,3230,3240,3250,3260,3270,3280,3290,3300,3310,3320,3330,3340,3350,3360,3370,3380,3390,3400,3410,3420,3430,3440,3450,3460,3470,3480,3490,3500,3510,3520,3530,3540,3550,3560,3570,3580,3590,3600,3610,3620,3630,3640,3650,3660,3670,3680,3690,3700,3710,3720,3730,3740,3750,3760,3770,3780,3790,3800,3810,3820,3830,3840,3850,3860,3870,3880,3890,3900,3910,3920,3930,3940,3950,3960,3970,3980,3990,4000,4010,4020,4030,4040,4050,4060,4070,4080,4090,4100,4110,4120,4130,4140,4150,4160,4170,4180,4190,4200,4210,4220,4230,4240,4250,4260,4270,4280,4290,4300,4310,4320,4330,4340,4350,4360,4370,4380,4390,4400,4410,4420,4430,4440,4450,4460,4470,4480,4490,4500,4510,4520,4530,4540,4550,4560,4570,4580,4590,4600,4610,4620,4630,4640]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Year sales",2000,2001,2002,2003,2004,2005,2006,2007,2008,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Product 1",1000,1010,1020,1030,1040,1050,1060,1070,1080,1090,1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290]

{"sheet":"Excel limits","index":15,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["IBB Bank (Geneva)"]
[]
["Amount",400000]
["Rate",1.4999999999999999E-2]
["Number of years",25]
[]
["Reimbursement Schedule"]
["Year","Interest","Reimbursement","Fixed Annuity"]
[1,{"$f":"-IPMT($B$5,A10,$B$6,$B$4)","v":6000},{"$f":"-PPMT($B$5,A10,$B$6,$B$4)","v":13305.38156196093},{"$f":"-PMT($B$5,B6,$B$4)","v":19305.38156196093}]
[3,5597.8448422897309,13707.5367196712]
[5,5183.5345449376682,14121.847017023263]
[7,4756.7017188481404,14548.67984311279]
[9,4316.9678705900569,14988.413691370875]
[11,3863.9430667683723,15441.438495192559]
[13,3397.2255882511763,15908.155973709756]
[15,2916.4015739457996,16388.979988015129]
[17,2421.0446538080423,16884.336908152891]
[19,1910.7155707591214,17394.665991201811]
[21,1384.9617911750465,17920.419770785884]
[23,{"$f":"-IPMT($B$5,A21,$B$6,$B$4)","v":843.31710360304339},{"$f":"-PPMT($B$5,A21,$B$6,$B$4)","v":18462.064458357887}]
[25,285.30120534917631,19020.080356611757]
[]
[]
[]
[]
[]
[]
[null,null,null,"Hints"]
[null,null,null,"Excel cannot automatically detect that the analysis is done \"by year\""]
[null,null,null,"If selected, the year column is understood as a series !"]
[null,null,null,"If not selected, the horizontal axis shows : 1-2-3-4 instead of 1-3-5-7 …"]
[]
[null,null,null,"Whatever : button SELECT DATA and remove extra series and"]
[null,null,null,"select correct source data for horizontal axis"]
[]
[]
[null,null,null,"It is also possible to create such a chart using a SCATTER type (linked points)"]
[null,null,null,"Select from A9 to C20"]
[null,null,null,"But still necessary to select correct source data for horizontal axis and more annoying :"]
[null,null,null,"it does not go by 1-3-5 … if you set the major unit to go by 2 you will get 0-2-4-5 …"]
[null,null,null,"therefore : lines are better …."]

{"sheet":"VIH-Switzerland 2","index":16,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["Evolution of AIDS in Switzerland (source : Office Fédéral de la Statistique)"]
[]
["Year",1999,2000,2001,2002,2003,2004,2005,2006,2007,2008]
["Casualties - Men",112,116,134,125,94,95,100,70,56,9]
["Casualties - Women",65,57,55,52,29,36,39,32,14,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"from"]
[null,null,null,null,null,null,null,null,"Hints"]
[null,null,null,null,null,null,null,null,"Same as previous exercice"]
[null,null,null,null,null,null,null,null,"Simply remove the false \"Testing year\" series"]
[null,null,null,null,null,null,null,null,"And retrieve X axis labels"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"to "]

{"sheet":"Tax","index":17,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Here below the chart built on the \"green\" selection :"]
["INCOME","January","February","March","April","May","June"]
["Systems",150000,100000,115000,115000,90000,98000]
["Software",95000,40000,50000,50000,48000,36000]
["Hardware",25000,10000,8000,7500,9800,10000]
["Services",63000,50000,45000,47000,59000,48000]
["Total income",{"$f":"SUM(B10:B13)","v":333000},200000,218000,219500,206800,192000]
[]
[]
["COSTS"]
["Salaries",109000,98000,99000,93000,95000,83000]
["Telephone",7500,6000,5500,4500,6300,7200]
["Rent",25000,25000,25000,25000,25000,25000]
["Total Costs",{"$f":"SUM(B18:B20)","v":141500},129000,129500,122500,126300,115200]
[]
[]
["Gross Profit",{"$f":"B14-B21","v":191500},71000,88500,97000,80500,76800]
["Estimated Tax",{"$f":"B24*$B$29","v":38300},14200,17700,19400,16100,15360]
["Estimated Net",{"$f":"B24-B25","v":153200},56800,70800,77600,64400,61440]
[]
[]
["Average tax rate - according to previous years",0.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If the chart is built without the yellow cell, it is a total mess !"]
["And trying to work it out manually is useless …"]
[]
["Simply include the yellow cell in the selection and the chart is OK ! "]
[]
["You may also keep the green selection but without the series name in A26. The graph will be OK but the "]
["series name will be \"Serie 1\" and you will have to retrieve the correct label through the SELECT DATA button."]

{"sheet":"Secondary axis","index":18,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number of houses sold","Total sales","Price per unit"]
["House A",25,{"$f":"B3*D3","v":15000000},600000]
["House B",50,{"$f":"B4*D4","v":25000000},500000]
["House C",90,{"$f":"B5*D5","v":36000000},400000]
["House D",30,{"$f":"B6*D6","v":21000000},700000]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"CHANGE CHART TYPE button"]
[null,null,null,null,null,null,null,null,null,"Do not change the type because it will affect the whole chart …"]
[null,null,null,null,null,null,null,null,null,"Select at bottom of dialog box the corresponding series"]
[null,null,null,null,null,null,null,null,null,"Change the type"]
[]
[null,null,null,null,null,null,null,null,null,"Add secondary axis (working on the series options and not through adding elements)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Other possibility : choose \"logarithmic scale\" for the y axis"]
["advantage : no visible secondary axis - possibility to add another series such as the price per unit"]

{"sheet":"Error bars","index":19,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number of houses on sale","Estimated sales"]
["House A",25,20]
["House B",50,45]
["House C",90,80]
["House D",30,28]

{"sheet":"Error bars - custom","index":20,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Tests","Step 1","Step 2","Step 3"]
["Average result",25,20,29]
["Scenario 1 - more",3,5,3]
["Scenario 2 - less",5,3,1]
[]
[]
[]
[]
["Column understanding (ONE series)",null,null,null,"Row understanding (THREE series)"]

{"sheet":"Trend line","index":21,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Trend line is found in the list of elements you can add to a chart"]
[]
["Swarovski",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Jan",29]
["beads",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Feb",43]
["Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mar",64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Apr",89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"May",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Jun",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Jul",195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Aug",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Sep",318]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Oct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Nov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dec"]
[]
[]
[]
[]
[]
[]
[null,"The source cells include the missing data"]
[]
[]
["What is asked : add a trend line that will show the possible sales for the missing Nov-Dec months"]
[]
[]
[{"$f":"A3","v":"Swarovski"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Jan",29]
[{"$f":"A4","v":"beads"},null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Feb",43]
["Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mar",64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Apr",89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"May",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Jun",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Jul",195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Aug",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Sep",318]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Oct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Nov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Dec"]
[]
[]
[]
[]
[]
[]
[null,"Equation : option in the dialog box"]

{"sheet":"Trend line and equation","index":22,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Average height according to age"]
["x","y"]
["Height  in m","Age"]
[1.2,10]
[1.4,12]
[1.6,14]
[1.7,16]
[1.8,18]
[]
[]
[]
[]
[]
[]
[]
["The trend line indicates the progression"]
["The equation will let you calculate the height for an age omitted in the source data"]
["A 17 years old teeager would be ….. high"]
[]
[]
["The equation : ",null,"y = 12.931x - 5.9138"]
[null,null,"y=y axis point or in plain word : the age"]
[]
[]
["A bit of algèbre …",null,"17=12.931x-5.9138",null,null,"14=12.931x-5.9138",null,null,"18=12.931x-5.9138"]
[null,null,"5.9138+17=12.931x-5.9138+5.9138",null,null,"5.9138+14=12.931x-5.9138+5.9138",null,null,"5.9138+18=12.931x-5.9138+5.9138"]
[null,null,"5.9138+17=12.931x",null,null,"5.9138+14=12.931x",null,null,"5.9138+18=12.931x"]
[null,null,"22.9138=12.931x",null,null,"19.9138=12.931x",null,null,"23.9138=12.931x"]
[null,null,"x=22.9138/12.931",null,null,"x=19.9138/12.931",null,null,"x=23.9138/12.931"]
[null,null,{"$f":"22.9138/12.931","v":1.7720052586806898},null,null,{"$f":"19.9138/12.931","v":1.5400046400123732},null,null,{"$f":"23.9138/12.931","v":1.8493387982367953}]
[]
["personal comment : you need to be better at maths than me ….. I wonder why 14 and 18 rechecked with the formula don't show the same figure as in the chart ….."]

{"sheet":"Bars","index":23,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
["Part of active population (25-64 and 25-34) with a diploma of secondary cycle (2008)"]
[]
[]
["In %","25-64","25-34"]
["Australia",69.900000000000006,82.5]
["Finland",81.8,90.1]
["France",70,82.9]
["Germany",85.3,85.8]
["Hungaria",79.7,85.6]
["Italy",53.3,68.900000000000006]
["Netherlands",73.3,82.4]
["OCDE (average)",71.099999999999994,80]
["Spain",51.2,65]
["Sweden",85,91.2]
["United Kingdom",69.599999999999994,46.6]
["United States",88.7,88.1]
[]
["Hints"]
["Add data labels (Outside End)"]
["Remove gridlines (click and DEL)"]
["Remove horizontal axis (click and DEL)"]
["Apply special colors to France and OCDE"]

{"sheet":"Area","index":24,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["Evolution from 1980 to 2011 of access to baccalauréat in France"]
[]
["In %","Bac \ngénéral","Bac \ntechnologique","Bac \nprofessionnel"]
[1985,22,{"$f":"38-22","v":16}]
[1986,23,{"$f":"40-23","v":17},null,"source : Ministère Education Nationale "]
[1987,24,{"$f":"42-24","v":18},1,"leaflet handed out to parents"]
[1988,26,{"$f":"45-26","v":19},2,"around year 2004"]
[1989,35,{"$f":"48-35","v":13},4]
[1990,35,{"$f":"50-35","v":15},{"$f":"55-50","v":5}]
[1991,37,{"$f":"54-37","v":17},{"$f":"60-54","v":6}]
[1992,38,{"$f":"55-38","v":17},{"$f":"65-55","v":10}]
[1993,38,{"$f":"57-38","v":19},{"$f":"66-57","v":9}]
[1994,40,{"$f":"61-40","v":21},{"$f":"71-61","v":10}]
[1995,37,{"$f":"57-37","v":20},{"$f":"69-57","v":12}]
[1996,36,{"$f":"56-36","v":20},{"$f":"69-56","v":13}]
[1997,35,{"$f":"55-35","v":20},{"$f":"70-55","v":15}]
[1998,35,{"$f":"55-35","v":20},15]
[1999,35,{"$f":"55-35","v":20},15]
[2000,34.200000000000003,21.7,14]
[2001,33.9,21.1,14.2,"source : INSEE - Internet on 23.10.2013"]
[2002,33.700000000000003,21,14.2]
[2003,33.9,20.7,14.2]
[2004,34.6,20.399999999999999,14.4]
[2005,35.1,19.899999999999999,14.7]
[2006,35.1,18.8,15.2]
[2007,35.5,18.600000000000001,15.8]
[2008,36.4,18.3,16.3]
[2009,36.5,17.899999999999999,17]
[2010,37.299999999999997,17.7,23.8]
[2011,38.5,17.100000000000001,31.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hints"]
["Area (preferably no 2)"]
["Button  SELECT DATA",null,null,null,"<==","2016 release : sometimes it goes straight through with a good understanding"]
["- remove extra series created for \"In %\""]
["- select the correct source range of cells for the years"]
["Horizontal axis : labels to align vertically"]
["Vertical axis : impossible to display 20% because source data is not 0.2 but 20 !"]

{"sheet":"Scatter","index":25,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
["Profitability",64,128,256,512,1024,2048]
["A",79,85,69,65,48,75]
["B",56,74,41,45,84,76]
["C",78,47,52,85,95,86]
["D",96,58,63,59,84,89]
[]
["Usual chart - X data is understood as linear values : FALSE !!!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Caution"]
["Excel understands PROFITABILITY as a series (remove it)"]
["Category (X) axis labels are not read properly"]
[]
["Chart type SCATTER    -     X values are understood as logarithmic - OK …",null,null,null,null,null,null,null,"2016  ==>","the suggestions include one with smoothed lines"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Caution"]
["Choose type number 2 or 4 (with smoothed lines - with straight lines)"]
["Work on the horizontal axis : max 2048 - major unit 256 (to show mutliple of 64)"]
["Caution : never type 64K - 256K … in source data or the axis will be standard whatever the type of chart"]
[]
[]
["Special : alternatives to Scatter type when source data is not \"linear\""]
[]
["Sales","2019-01-01","2019-06-01","2019-08-01"]
["Product 1",16894,18854,23000]
["Product 2",20210,19632,25784,null,null,null,"Automatic scatter with straight line and markers"]
["Product 3",18052,21135,22458]
["Product 4",16000,20456,24182]
[]
["Automatic columns "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["In the dialog box for horizontal axis, you will see that Axis Type is set on automatic. "]
["Try dates : same result"]
[null,null,null,null,null,null,null,"Nothing can be done "]
["If  you want to remove those \"holes\", set the axis type on Text",null,null,null,null,null,null,"The dialog box does not provide an option to hide the \"holes\""]
[null,null,null,null,null,null,null,"(which is normal as this is what scatters are for …)"]

{"sheet":"Swiss Population","index":26,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["Swiss population over the years (rounded data except the last 3 figures)"]
["Year","Population"]
[1800,1800000]
[1820,1956000]
[1850,2392000]
[1880,2831000]
[1900,3315000]
[1910,3753000]
[1920,3880000]
[1930,4066000]
[1941,4265000]
[1950,4714000]
[1960,5429000]
[1970,6269000]
[1980,6365000]
[1990,6673000]
[2000,7209000]
[2004,7364148]
[2008,7701856]
[2012,8036917]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Here creating a scatter chart is a must, whatever the real nature of dates"]
["Indeed the gap between the years is not equal"]
["(and moreover, Excel would not understand the \"year\" 1800 !)"]
[]
["Hints"]
["Make sure the type shows the markers (to make gap between years evident)"]
["As usual : if necessary remove extra series of dates and point to correct cells for the horizontal axis"]
["Work on the axis : change the minimum (1800), maximum (2015), major unit (10)    - Labels are also ABOVE"]
["Align the labels vertically"]
["Add data labels for the series but show only the years (X Value) and of course keep Leader Lines"]
["Select the last 3-4 and move them as they are really too close"]

{"sheet":"Fertility rate","index":27,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Other example for a scatter chart"]
[]
[null,null,null,null,"Normal line chart built on the green selection : impossible !",null,null,null,null,null,"Scatter chart also built on the green selection"]
["Country","Fertility rate\n(not real !)","% women between 15-64"]
["A",1.2,42]
["BE",1.5,38]
["CH",1.2,35]
["D",1.1000000000000001,38]
["DK",1.7,51]
["FIN",2,54]
["FR",1.3,45]
["GR",1.5,47]
["IT",1,32]
["NL",1.2,22]
[null,"x","y"]
[]
[]
[]
[null,null,null,"There should be only one series : % women and the horizontal axis should",null,null,null,null,null,"This time the comprehension is correct. Simply work on the X axis scale"]
[null,null,null," display the fertility rates in ascending order",null,null,null,null,null,"(min : 0.9, max : 2, major unit : 0.1)"]
[null,null,null,"You can remove the Fertility series and re-define the horizontal axis labels"]
[null,null,null,"but oups : they are not in ascending order and no modification is possible …",null,null,null,null,null,"New since 2013 : the labels can  point to a free range of cells"]
[]
[null,null,null,null,null,null,null,null,null,"Select the series and click on the PLUS button (on the right of chart)"]

{"sheet":"Pie special","index":28,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Sales","Year 2020"]
["Office 2019",900,null,"Note : the \"small\" series must always be the last ones !"]
["Office 2016 subscription",300]
["Office 2016 licence",100]
["Publisher",20]
["Ms Project",15]
["Adobe Acrobat DC",13]
["Divers",10]
[]
[]
["Hints"]
["Choose corresponding chart directly from the available types"]
["Add data labels (category + percentage only) - keep leader lines"]
["Series FORMAT dialog box - in the SERIES OPTIONS - make sure the second plot contains last 4 series "]
["Remove legend"]
["If necessary : enlarge plot area"]

{"sheet":"Columns and negative values","index":29,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,3,11,4]]}
[]
["Year temperatures average - CANADA"]
[]
[null,"Max","Min"]
["St. John's",8.6,0.8]
["Charbottetown",9.5,0.8]
["Halifax",10.7,1.4]
["Fredericton",11,0.61,"Columns with a few modifications (labels vertical alignment, adding chart title, legend at the top …)"]
["Québec",9,-1]
["Montréal",10.9,1.2]
["Ottawa",10.7,0.8]
["Toronto",12.6,5.2]
["Winnipeg",8.1,-3.4]
["Regina",8.9,-3.8]
["Edmonton",8.6999999999999993,1.5]
["Calgary",10.3,-2.6]
["Vancouver",13.5,6.1]
["Victoria",13.9,5.0999999999999996]
["Whitehouse",4.0999999999999996,-6.2]
["Yellowknife",-0.8,-9.6999999999999993]
[]
[]
[null,null,null,null,null,null,null,"The X axis labels should be at the bottom of chart !"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"How to remove the tick marks on the axis line ?"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Vertical lines : simple minor gridlines !"]

{"sheet":"Radar","index":30,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Comparative analysis","Price","Quality","Design","Options","Services"]
["product A - ours",80,90,50,60,90]
["product B - theirs",100,80,70,80,70]
[]
[]
["The figures can come from internal tests, evaluation questions to clients and so on..."]
["The answers have been added and converted into percentages"]
[]
["Note : the same type of chart could be used for analysing people : work, adaptability, QI, performances …"]
[]
[]
["Analysis : ","The chart created using above figures will show whether the product price is "]
[null,"slightly above market if we should improve our design and options …"]
[]
[]
[null,null,null,null,null,"* Office 2016-2019 : tick marks for axis"]
[null,null,null,null,null,"combination a bit funny (if you do not "]
[null,null,null,null,null,"do it this way the marks are not"]
[null,null,null,null,null,"displayed ….. ????"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hints"]
["Radar type 2 (with markers)"]
["Remove gridlines"]
["Vertical axis","test in 2016 : impossible to show the line as before !    ????"]
[null,"change major unit from 20 to 10 "]

{"sheet":"Stock","index":31,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,0,21,4],[23,0,23,4]]}
[]
["Date","Min","Max","Closing",null,null,"Port productivity"]
["2001-04-03",55.25,56.375,55.625]
["2001-04-04",54.125,56,55.5,null,null,"Containers movements","Min","Max","Average"]
["2001-04-05",56,56.375,56.25,null,null,"Antwerp",250,600,{"$f":"AVERAGE(H5:I5)","v":425}]
["2001-04-06",55.125,56.375,56.5,null,null,"Havre",200,700,{"$f":"AVERAGE(H6:I6)","v":450}]
["2001-04-07",56,56.625,55.625,null,null,"Hambourg",300,550,{"$f":"AVERAGE(H7:I7)","v":425}]
[null,null,null,null,null,null,"Marseille",280,530,{"$f":"AVERAGE(H8:I8)","v":405}]
[null,null,null,null,null,null,"Nice",400,890,{"$f":"AVERAGE(H9:I9)","v":645}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Caution : if Excel displays a msg box reminding you of the data order expected for the chosen stock type , it means that your data do not respect this order. Click on the OK button but no chart will be created. It is the case for example if you choose type no 2 using the above colored range of cells. You need to select type 1."]
[]
["By default markers are small and rectangular. They have been modified.\nSelect series (here the CLOSING one)\nClick on the painting pot - select below MARKERS"]

{"sheet":"Bubbles","index":32,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Info : in 2016 bubbles are in the scatter section !"]
["Affiliate","Number of products","Sales","Market position"]
["Affiliate A",10,80000,25]
["Affiliate B",12,60000,20]
["Affiliate C",3,90000,30]
["Affiliate D",25,30000,10]
[null,"size","y","x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Hints"]
["No need to select a given range of cells before creating the chart : Excel understands wrongly everYthing !"]
["Select a range just to create the chart then cllick on the SELECT DATA button and remove everything"]
["Then click on the ADD button and start building the series, specifying the X, Y, size data"]

{"sheet":"Scatter-bubble for 2 dimensions","index":33,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Britain","Italy","France"]
["Power distance x",2,4,6]
["Individualism y",5,10,15]
[]
["Scatter chart ",null,null,null,null,null,null,"Bubble chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Create a scatter and then SELECT DATA button : remove everything",null,null,null,null,"Create bubble and then SELECT DATA button : remove everything"]
["ADD button and create a serie for each country",null,null,null,null,"ADD button and create a serie for each country"]
[null,null,"Power is the X value",null,null,null,null,null,"Power is the X value"]
[null,null,"Individualism is the Y value",null,null,null,null,null,"Individualism is the Y value"]
[null,null,null,null,null,null,null,null,"Leave size untouched ={1}"]
[null,null,null,null,null,null,null,null,null,"(this means you could add a third figure …)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Add the name as a data label for each serie"]
["Click on the marker to change its type"]
[null,null,null,null,null,"Add the name as a data label for each serie"]

{"sheet":"Tableau de bord","index":34,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Tableau de bord Points d'attention / risques",null,null,null,null,null,null,null,null,null,"Administré par :"]
[null,null,null,null,null,null,null,null,null,null,"Mis à jour le :","2008-03-18"]
["Ref.","Size","Type","Description","Impacts Potentiels","Prob.\n (1-10)","Impact \n(1-10)","Evolution","Statut","Date\ncréation","Par","Date\nrésolution","Resp.","Actions correctrices","Reduce to 50%","Reduce to zero","Date Closed","Days Open","Critical (1/0)"]
["A",3,"Operationel",null,null,7,5,"Stable","Open ","dec 2006","PBD",null,"MSD"]
["B",4,"Opérationnel",null,null,3,4,"Stable","Clos","2007-01-01","PLS","fev 2007","TDS"]
["C",3,"Opérationnel",null,null,8,1,"Stable","Clos","2007-01-01","PLS","fev 2007","TDS"]
["D",3,"Opérationnel",null,null,3,4,"Amélioration","Open ","2007-01-01","MSD",null,"LAC"]
["E",3,"Opérationnel",null,null,2,4,"Stable","Open ","2007-06-01","PLS",null,"PLS"]
["F",3,"Opérationnel",null,null,2,5,"Amélioration","Open ","Q4 2007","PLS",null,"PBD"]
["G",3,"Opérationnel",null,null,6,7,"Aggravation","Open ","2008-02-26","WKN",null,"PBD\nPLS"]
["H",3,"Planning",null,null,6,4,"Amélioration","Open ","2008-02-26","SNN",null,"BLC"]
["I",2,"Technologique",null,null,2,4,"Stable","Open ","2008-02-04","PWR",null,"PWR"]
["J",3,"Planning",null,null,9,3,"Aggravation","Open ","2008-03-10","SNN",null,"PBD\nPLS"]
["K",2,"Technologique",null,null,3,4,"Stable","Open ","Janv 2008","PLS",null,"MSD"]

{"sheet":"Graphique probabilité impact","index":35,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,0,24,5],[24,6,24,11],[25,0,25,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Series : each \"data-point\" is a series to which 3 variables have been assigned",null,null,null,null,null,"Representing risk through color shading : gradient fill with 3 colors (1 = green - 2 = orange - 3 = red). Choose the direction and then work on the three stops"]
["Texts and arrows along axes (X and Y) : "]
["100% manual"]

{"sheet":"Sparkline","index":36,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Sparkline chart = mini chart inside a cell"]
[]
["Additional seasonal workers"]
[]
[null,"Business","Agriculture","Tourism"]
["January",0.02,0.01,0.01]
["February",0.02,0.01,0.01]
["March",0.02,0.01,0.01]
["April",0.02,0.01,0.01]
["May",0.02,0.1,0.05]
["June",0.02,0.12,0.08]
["July",0.04,0.15,0.15]
["August",0.04,0.2,0.15]
["September",0.02,0.15,0.08]
["October",0.02,0.1,0.01]
["November",0.08,0.01,0.01]
["December",0.1,0.01,0.1]
["Sparkline"]

{"sheet":"Drawn shapes","index":37,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Rain : average for July"]
["EUROPE","Number of days"]
["Amsterdam",10]
["Athens",1]
["Barcelona",5]
["Berlin",9]
["Dublin",13]
["Geneva",9]
["Istanbul",3]
["Lisbon",3]
["Madrid",3]
["Moscow",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienna",9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Some hints"]
["Position",null,"ALT and drag = follow underlying cells"]
["Perfect shape",null,"Press the SHIFT key while drawing (release mouse button first)"]
["Drawing from the center outwards",null,"Press the CTRL key while drawing (release mouse button first)"]
["Perfect from the center !!!",null,"Combine the above two keys ! "]
["Shape anchor",null,"According to active object : click on the chart ==> shape belongs to the chart / click onto the sheet ==> free"]
["Face shape",null,"By default it is smiling. To turn it into a sad face : drag the little yellow round button."]
[null,null,"Hint : zoom in otherwise you hardly see the button"]

{"sheet":"Drawn shapes - To do","index":38,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Rain : average for July"]
["EUROPE","Number of days"]
["Amsterdam",10]
["Athens",1]
["Barcelona",5]
["Berlin",9]
["Dublin",13]
["Geneva",9]
["Istanbul",3]
["Lisbon",3]
["Madrid",3]
["Moscow",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienna",9]

{"sheet":"SmartArt","index":39,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SmartArt - To do","index":40,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}