{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Index","Démo","Comprehension Excel","Graphique incorporé","Graphique pleine page","Travail simple","Cellule vide & col masquée","Travail d'un élément","Utiliser le bouton entonnoir","Pluie-Europe","VIH-Suisse","Dépenses ménages Suisse","Ressources énergétiques","Travail sur les axes","Travail sur les axes - Réponse","Limites Excel","VIH-Suisse 2","Impôts","Axe secondaire","Barres erreur","Barres erreur - perso","Courbe tendance","Courbe tendance-équation","Barres","Aires","Nuages de points","Population Suisse","Taux de fertilité","Camembert spécial","Histo et valeurs négatives","Radar","Boursier","Bulles","Nuage-bulles - 2 dimensions","Tableau de bord","Graphique probabilité impact","Sparkline","Formes dessinées ","Formes dessinées - A faire","SmartArt","SmartArt - A faire"],"not_rendered":{"charts":68,"images":27,"macros":1,"external_links":0,"defined_names":35,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Graphique pleine page","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":38,"n_cols":2,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Contenu"]
["Graphique Excel simple"]
[null,"Démos et explications"]
[null,"Pluie en Europe - 2004"]
[null,"VIH en Suisse"]
[null,"Dépenses ménages Suisse"]
[null,"Ressources énergétiques"]
[null,"Travail sur les axes"]
["Aider Excel lorsque la compréhension est mauvaise"]
[null,"Limites Excel"]
[null,"VIH en Suisse 2"]
[null,"Impôts"]
["Spécial"]
[null,"Axe secondaire"]
[null,"Barres d'erreur"]
[null,"Barres d'erreur - 2"]
[null,"Courbe de tendance"]
[null,"Courbe de tendance 2"]
["Exemples de graphiques moins courants"]
[null,"Barres"]
[null,"Barres erreur - perso"]
[null,"Nuage de points"]
[null,"Population Suisse"]
[null,"Taux de fertilité ( * avec étiquettes cellules libres)"]
[null,"Camembert spécial"]
[null,"Histo et valeurs négatives"]
[null,"Radar"]
[null,"Boursier"]
[null,"Bulles"]
[null,"Nuage-bulles - 2 dimensions"]
[null,"Bulles spéciales : 3 variables pour une série"]
[]
["Graphiques Sparkline"]
[null,"Exemple"]
[]
["Outils graphiques"]
[null,"Formes dessinées"]
[null,"Graphiques SmartArt"]

{"sheet":"Démo","index":1,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["\u008c","Comment Excel comprend votre sélection"]
[]
["\u008d","2 sortes de graphiques : incorporé - en pleine page"]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01",null,"Ventes","Suisse","France","Italie","Espagne","Portugal","Belgique",null,"Ventes","Suisse","France","Italie"]
["Produit 1",16894,18854,23000,null,"Produit 1",16894,18854,23000,24000,18000,21000,null,"Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784,null,"Produit 2",20210,19632,25784,19865,21563,24789,null,"Produit 2",20210,19632,25784]
["Produit 3",23000,21135,22458,null,"Produit 3",23000,21135,22458,23546,17896,21569,null,"Produit 3",23000,21135,22458]
["Produit 4",19580,20456,24182,null,"Produit 4",19580,20456,24182,19000,22569,18963,null,"Produit 4",19580,20456,24182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 5",24000,18000,21000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 6",19865,21563,24789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 7",23546,17896,21569]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 8",19000,22569,18963]
["\u008e","Premières actions sur le graphique créé",null,null,null,null,null,null,null,null,null,null,null,"Produit 9",21963,20147,21963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 10",19635,20365,20145]
[]
[]
[]
[null,"Spécial : cellules vides ou colonnes cachées … comment Excel gère-t-il cela ?"]
[]
[]
[]
[]
["\u008f","Travail en profondeur de chaque élément"]
[]
[]
[]
[]
[]
["\u0090","Le nouveau bouton ENTONNOIR"]

{"sheet":"Comprehension Excel","index":2,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["\u008c","Excel cherche des dates (attention des vraies !) - S'il n'en trouve aucune, alors il part du principe que les données les plus nombreuses en ligne ou en colonne correspondent au futur axe horizontal"]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01",null,"Ventes","Suisse","France","Italie","Espagne","Portugal","Belgique",null,"Ventes","Suisse","France","Italie"]
["Produit 1",16894,18854,23000,null,"Produit 1",16894,18854,23000,24000,18000,21000,null,"Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784,null,"Produit 2",20210,19632,25784,19865,21563,24789,null,"Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458,null,"Produit 3",23000,21135,22458,23546,17896,21569,null,"Produit 3",23000,21135,22458]
["Produit 4",16000,20456,24182,null,"Produit 4",19580,20456,24182,19000,22569,18963,null,"Produit 4",19580,20456,24182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 5",24000,18000,21000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 6",19865,21563,24789]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 7",23546,17896,21569]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 8",19000,22569,18963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 9",21963,20147,21963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 10",19635,20365,20145]

{"sheet":"Graphique incorporé","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Créer un graphique en testant les méthodes suivantes : "]
[null,1,"Sélectionner les données source + le bouton ANALYSE RAPIDE"]
[null,2,"Sélectionner les données source + le bouton GRAPHIQUES RECOMMANDES (onglet INSERTION du ruban)"]
[null,3,"Sélectionner les données source + choisir parmi les types de graphiques (Onglet INSERTION et groupe GRAPHIQUES)"]
[null,null,"Jeter un œil à la liste complète (Boîte de dialogue)"]
[]
["\u008d","Un graphique incorporé est comme un objet",null,null,null,"Utiliser les poignées pour redimensionner (pas besoin de respecter les proportions comme pour une image)"]
[null,"(image, forme dessinée …)",null,null,null,"Cliquer-glisser pour déplacer"]
[null,null,null,null,null,"Pour imprimer les données et le graphique : cellule active dans la feuille"]
[null,null,null,null,null,"Pour imprimer uniquement le graphique : cliquer sur le graphique"]
["Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458]
["Produit 4",16000,20456,24182]
[]
[null,"Pour transformer le graphique incorporé en graphique pleine page  : bouton DEPLACER LE GRAPHIQUE (dernier bouton de l'onglet CREATION)"]

{"sheet":"Travail simple","index":5,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Onglet CREATION : "]
[]
["Bouton SELECTIONNER DES DONNEES pour contrôler la compréhension d'Excel"]
["Bouton INTERVERTIR LIGNE / COLONNE pour inverser la compréhension d'Excel"]
["Bouton DEPLACER LE GRAPHIQUE pour passer de incorporé à pleine page ou vice versa"]
["Bouton MODIFIER LE TYPE DE GRAPHIQUE pour changer le type (histo, aire, courbes …)"]
["La galerie des STYLES pour ajouter du \"look\" au graphique (aussi le bouton pinceau au sommet droit du graphique lorsqu'il est sélectionné)"]
["La galerie DISPOSITION RAPIDE pour ajouter des éléments (suggestions déjà faites)"]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458]
["Produit 4",16000,20456,24182]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458]
["Produit 4",16000,20456,24182]
["Produit 5",20000,21000,23000]
[]
["Ajouter une série"]
[]
[null,"Si contiguë : cliquer-glisser les références dans les données source"]
[null,"Simple COPIER-COLLER"]
[]
[null,"Moins pratique mais de temps à autre utile …"]
[null,"Bouton SELECTIONNER DES DONNEES"]

{"sheet":"Cellule vide & col masquée","index":6,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
["Cellule vide",null,null,null,null,null,null,null,null,null,null,null,null,"Colonne masquée"]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 1",16894,18854,23000,null,null,null,null,null,null,null,null,null,"Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 2",20210,null,25784,null,null,null,null,null,null,null,null,null,"Produit 1",16894,18854,23000]
["Produit 3",18052,21135,22458,null,null,null,null,null,null,null,null,null,"Produit 2",20210,19632,25784]
["Produit 4",16000,20456,24182,null,null,null,null,null,null,null,null,null,"Produit 3",18052,21135,22458]
["Produit 5",20000,21000,23000,null,null,null,null,null,null,null,null,null,"Produit 4",16000,20456,24182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit 5",20000,21000,23000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"La colonne de février est masquée dans les données mais elle est affichée dans le graphique …."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Nouveau"]
[]
[]
[]
[]
[]
[]
[]
["Ventes","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-01-01",20000]
["Produit 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,"Par défaut non coché : la cellule #N/A est ignorée et appartient à la zone de traçage",null,null,null,null,null,null,null,null,"Option cochée : "]
[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":"Travail d'un élément","index":7,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Ventes pour la Suisse"]
["Ventes","2020-01-01","2020-02-01","2020-03-01"]
["Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458]
["Produit 4",16000,20456,24182]
[]
[]
[null,null,null,null,null,"Spécial et très facile : lier le titre du graphique au contenu d'une cellule en particulier"]
[]
[null,null,null,null,null,"Sélectionner le titre (pas besoin que le curseur soit dedans, de supprimer des caractères …)"]
[null,null,null,null,null,"Taper le signe = dans la barre de formule"]
[null,null,null,null,null,"Sélectioner la cellule contenant le texte"]
[null,null,null,null,null,"Enter ou Retour"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\u008f","Sélectionner et afficher le panneau de travail"]
[]
["Double-clic sur l'élément",null,null,null,"==>","Le volet de travail est automatiquement affiché à droite"]
[]
["Clic and onglet FORMAT - 1ère liste déroulante à gauche",null,null,null,"==>","Clic sur MISE EN FORME DE LA SELECTION pour afficher le volet"]
[]
["Onglet CREATION et bouton AJOUTER UN ELEMENT GRAPHIQUE",null,null,null,"==>","Liste déroulante : suggestions toutes faites ou options complètes et affichage du volet"]
["Bouton PLUS affiché au sommet droit du graphique (si graph. sélectionné)"]

{"sheet":"Utiliser le bouton entonnoir","index":8,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Ventes annuelles",2010,2011,2012,2013,2014,2015,2016,2019,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Produit 1",1100,1110,1120,1130,1140,1150,1160,1170,1180,1190,1200,1210,1220,1230,1240,1250,1260,1270,1280,1290,1300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pointer",null,null,null,null,"Tous les autres points sont grisés"]
["Décocher puis bouton APPLIQUER",null,null,null,null,"Seuls les points sélectionnés restent affichés"]

{"sheet":"Pluie-Europe","index":9,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Pluie : moyennes pour Juillet"]
["EUROPE","Nombre de jours"]
["Amsterdam",10]
["Athènes",1]
["Barcelone",5]
["Berlin",9]
["Dublin",13]
["Genève",9]
["Istanbul",3]
["Lisbonne",3]
["Madrid",3]
["Moscou",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienne",9]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Titre du graphique"]
[null,null,null,null,null,null,null,null,null,null,null,"Sélectionner le titre"]
[null,null,null,null,null,null,null,null,null,null,null,"Saisir le signe = dans la barre de formule"]
[null,null,null,null,null,null,null,null,null,null,null,"Clic sur B1"]
[null,null,null,null,null,null,null,null,null,null,null,"RETOUR"]

{"sheet":"VIH-Suisse","index":10,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Sida - quelques chiffres : évolution des décès en Suisse (source : Office Fédéral de la Statistique)"]
[]
["Année","1999-01-01","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"]
["Masculin",112,116,134,125,94,95,100,70,56,9]
["Féminin",65,57,55,52,29,36,39,32,14,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Pour chaque série dans la boîte de format de la série : "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Si jamais votre axe horizontal affiche plusieurs fois les années, il faut simplement"]
["travailler l'axe : choisir des unités en années et non en mois"]

{"sheet":"Dépenses ménages Suisse","index":11,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Dépenses moyennes des ménages",null," - source OFS - année 2011"]
["Revenu brut moyen",9604]
["Assurances (sociales et maladie de base)",2646]
["Transferts monétaires à d'autres ménages",208]
["Autres assurances (maladie complémentaire)",575]
["Consommation",5394]
["Epargne",781]
["Total",{"$f":"SUM(B4:B8)","v":9604}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Affichage des lignes de connection : il suffit de glisser un peu le label et c'est automatique"]
[null,null,null,null,null,null,"Pour sortir la tranche : cliquer jusqu'à ce qu'elle soit sélectionnée - puis glisser"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["info 2009 - Relevé dans le 20 minutes de novembre 2011 (selon OFS)"]
[]
["Revenu mensuel brut :",null,null,9369]
["Impôts",0.12,{"$f":"$D$42*B43","v":1124.28}]
["Assurances sociales (AVS …)",0.1,{"$f":"$D$42*B44","v":936.90000000000009}]
["Assurance maladie",0.05,468.45000000000005]
["Divers autres",{"$f":"C46/D42","v":2.031913758138541E-2},{"$f":"C47-SUM(C43:C45)","v":190.36999999999989}]
[null,null,2720]
[]
[null,null,null,{"$f":"D42-C47","v":6649},"Budget moyen mensuel"]
["Logement et énergie",0.16,{"$f":"$D$42*B50","v":1499.04}]
["Epargne",0.124,{"$f":"$D$42*B51","v":1161.7560000000001}]
["Autres dépenses",0.154,1442.826]
["Transports",7.6999999999999999E-2,721.41300000000001]
["Alimentation, boissons",7.0000000000000007E-2,655.83]
["Loisirs et culture",6.7000000000000004E-2,627.72300000000007]
["Restauration, hôtels",5.8000000000000003E-2,543.40200000000004]
[]
["39% des ménages  : plusieurs personnes travaillent"]
["59% des ménages = retraités"]

{"sheet":"Ressources énergétiques","index":12,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Des ressources trop sollicitées",null," - déc 2009 - à l'occasion du film de N. Vanier : Loup"]
[]
["Pétrole",0.43099999999999999]
["Electricité",0.16700000000000001]
["Gaz",0.153]
["Energies renouvelables et déchets",0.129]
["Charbon/tourbe",8.5999999999999993E-2]
["Autre",3.4000000000000002E-2]
[]
["Total : 8'084 millions de tonnes équivalent pétrole"]

{"sheet":"Travail sur les axes","index":13,"n_rows":37,"n_cols":366,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Travail sur l'axe horizontal"]
[]
[]
[]
[]
[]
["Vente année","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"]
["Produit 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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ventes année",2000,2001,2002,2003,2004,2005,2006,2007,2008,2010,2011,2012,2013,2014,2015,2016,2019,2020,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Produit 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":"Travail sur les axes - Réponse","index":14,"n_rows":43,"n_cols":366,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Travail sur l'axe horizontal"]
[]
[]
[]
[]
[]
[]
[]
["Ventes année","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"]
["Produit 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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ventes année",2000,2001,2002,2003,2004,2005,2006,2007,2008,2010,2011,2012,2013,2014,2015,2016,2019,2020,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Produit 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":"Limites Excel","index":15,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["IBB Banque (GENEVE) SA"]
[]
["Montant",400000]
["Intérêt",8.9999999999999993E-3]
["Nombre d'années",25]
[]
["Echéancier de remboursement"]
["Année","Intérêts","Amortissement","Total régulier par période"]
[1,{"$f":"-IPMT($B$5,A10,$B$6,$B$4)","v":3599.9999999999995},{"$f":"-PPMT($B$5,A10,$B$6,$B$4)","v":14339.034418322693},{"$f":"-PMT($B$5,B6,$B$4)","v":17939.034418322695}]
[3,3340.7359186823073,14598.298499640385]
[5,3076.7840835103098,14862.250334812383]
[7,2808.059735206567,15130.974683116128]
[9,2534.4765819611439,15404.557836361551]
[11,2255.9467717218913,15683.087646600803]
[13,1972.3808639837021,15966.653554338991]
[15,1683.6878010676992,16255.346617254994]
[17,1389.7748788811111,16549.25953944158]
[19,1090.5477171484681,16848.486701174224]
[21,785.91022910453705,17153.124189218157]
[23,{"$f":"-IPMT($B$5,A21,$B$6,$B$4)","v":475.76459063928354},{"$f":"-PPMT($B$5,A21,$B$6,$B$4)","v":17463.269827683409}]
[25,160.01120888493978,17779.023209437753]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Astuces"]
[null,null,null,"Excel n'arrive pas à reconnaître seul que l'analyse se fait par rapport aux années"]
["Lorsque la compréhension est mauvaise : ",null,null,"Si la colonne Année est sélectionnée, il  prend les années comme série !"]
[null,null,null,"Si elle ne l'est pas, l'axe affiche 1-2-3 au lieu de 1-3-5"]
[]
[null,null,null,"Il faut alors cliquer sur le bouton  SELECTIONNER DES DONNEES"]
[null,null,null,"et ôter la série en trop - resélectionner correctement les données source de l'axe X"]
[]
[null,null,null,"On peut aussi créer un graphique en nuages de points (reliés)"]
[null,null,null,"Sélection de A9 à C9"]
[null,null,null,"Mais on est quand même obligé de corriger la sélection des données source"]
[null,null,null,"pour l'axe X et plus embêtant : les étiquettes de l'axe des abscisses (X) affiche 1-2-3-4. "]
[null,null,null,"Même si on change l'unité principale - à 2 - on aura 0-2-4-5 …"]
[null,null,null,"Conclusion : graphique en courbes est meilleur …"]

{"sheet":"VIH-Suisse 2","index":16,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Sida - quelques chiffres : évolution des décès en Suisse (source : Office Fédéral de la Statistique)"]
[]
["Année",1999,2000,2001,2002,2003,2004,2005,2006,2007,2008]
["Masculin",112,116,134,125,94,95,100,70,56,9]
["Féminin",65,57,55,52,29,36,39,32,14,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Lorsque la compréhension est mauvaise : ",null,null,null,null,null,null,null,"Astuce"]
[null,null,null,null,null,null,"De",null,"Identique à l'exercice précédent"]
[null,null,null,null,null,null,null,null,"Il faut supprimer la fausse série Année de test"]
[null,null,null,null,null,null,null,null,"Il faut récupérer les étiquettes pour X : les années"]
[]
[]
[]
[null,null,null,null,null,null,null,"A"]

{"sheet":"Impôts","index":17,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"janvier","février","mars","avril","mai","juin"]
["REVENUS"]
["Systèmes",150000,100000,115000,115000,90000,98000,"Voici le graphique construit avec la sélection en vert :"]
["Logiciels",95000,40000,50000,50000,48000,36000]
["Fournitures",25000,10000,8000,7500,9800,10000]
["Services",63000,50000,45000,47000,59000,48000]
["TOTAL REVENUS",{"$f":"SUM(B11:B14)","v":333000},200000,218000,219500,206800,192000]
[]
[]
["DEPENSES"]
["Salaires",109000,98000,99000,93000,95000,83000]
["Téléphone",7500,6000,5500,4500,6300,7200]
["Loyers",25000,25000,25000,25000,25000,25000]
["TOTAL DEPENSES",{"$f":"SUM(B19:B21)","v":141500},129000,129500,122500,126300,115200]
[]
[]
["Bénéfice brut",{"$f":"B15-B22","v":191500},71000,88500,97000,80500,76800]
["Impôts approximatifs",{"$f":"B25*$B$29","v":38300},14200,17700,19400,16100,15360]
["Net approximatif",{"$f":"B25-B26","v":153200},56800,70800,77600,64400,61440]
[]
["Taux moyen d'imposition selon les  années précédentes",0.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Si on sélectionne uniquement la partie en vert, c'est la catastrophe !"]
["Et tenter de rafistoler ne sert à rien …"]
[]
["Il faut simplement inclure la cellule jaune et …. tout est OK !"]
[]
["Ou on peut aussi garder la sélection en vert mais sans la cellule A27 : le graphique sera OK mais le nom de "]
["la série sera \"série 1\" et il faudra aller récupérer le texte (par le bouton SELECTIONNER DES DONNEES)"]

{"sheet":"Axe secondaire","index":18,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nombre de maisons vendues","Ventes totales","Prix à l'unité"]
["Maison A",25,{"$f":"B3*D3","v":15000000},600000]
["Maison B",50,{"$f":"B4*D4","v":25000000},500000]
["Maison C",90,{"$f":"B5*D5","v":36000000},400000]
["Maison D",30,{"$f":"B6*D6","v":21000000},700000]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Bouton CHANGER LE TYPE DE GRAPHIQUE"]
[null,null,null,null,null,null,null,null,null,"Attention : si on change le type ==> appliqué à tout le graphique"]
[null,null,null,null,null,null,null,null,null,"Maintenant cela se passe dans la partie inférieure de la boîte de dialogue"]
[null,null,null,null,null,null,null,null,null,"Sélectionner la série en question et choisir le type"]
[]
[null,null,null,null,null,null,null,null,null,"Ajouter l'axe secondaire (travail sur la série et pas dans les ajouts d'éléments)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Autre possibilité : changer l'échelle de l'axe des ordonnées en \"échelle logarithmique\""]
["Avantage : pas de 2ème axe et on peut rajouter encore les prix à l'unité"]

{"sheet":"Barres erreur","index":19,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nombre de maisons en vente","Ventes estimées"]
["Maison A",25,20]
["Maison B",50,45]
["Maison C",90,80]
["Maison D",30,28]

{"sheet":"Barres erreur - perso","index":20,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Tests","Etape 1","Etape 2","Etape 3"]
["Résultat moyen",25,20,29]
["Variante 1 - plus",3,5,3]
["Variante 2 - moins",5,3,1]
[]
[]
[]
[]
["Compréhension en colonnes (1 série)",null,null,"Compréhension en lignes (3 séries)"]

{"sheet":"Courbe tendance","index":21,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,10,0,16]]}
[null,null,null,null,null,null,null,null,null,null,"La courbe de tendance se trouve dans la liste des éléments que l'on peut ajouter à un graphique"]
[]
["Perles",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Janv",29]
["Swarovski",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Févr",43]
["Ventes",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mars",64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Avr",89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Mai",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Juin",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Juil",195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Août",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Sept",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,"Déc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Demande : projection des ventes pour Octobre-Novembre-Décembre en tenant compte de l'évolution des mois précédents"]
[]
[]
[{"$f":"A3","v":"Perles"},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Janv",29]
[{"$f":"A4","v":"Swarovski"},null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Févr",43]
["Ventes",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Mars",64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Avr",89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Mai",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Juin",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Juil",195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Août",250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Sept",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,"Déc"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Les mois Oct-Nov-Dec manquent mais ils sont compris dans la plage de données générant le graphique"]
["La courbe de tendance exponentielle va calculer l'écart entre les différents mois et répércuter la progression sur les mois manquants !"]
[]
["Afficher l'équation : tout simplement clic sur l'onglet OPTIONS et case AFFICHER L'EQUATION SUR LE GRAPHIQUE !!!"]

{"sheet":"Courbe tendance-équation","index":22,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["Moyennes des tailles selon l'âge"]
["x","y"]
["Taille en m","Age"]
[1.2,10]
[1.4,12]
[1.6,14]
[1.7,16]
[1.8,18]
[]
[]
[]
[]
[]
[]
[]
["La courbe de tendance indique la progression"]
["L'équation permettrait de trouver la taille pour un age non indiqué dans le tableau des données source"]
["Un ado de 17 ans ferait … "]
[]
[]
["Explication de l'équation : ",null,"y = 19.28x - 17.07"]
[null,null,"y=age            -17.07 = quel point sur l'axe des ordonnées ? "]
[]
[]
["Un peu d'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}]
[]
["commentaire perso : pour tout comprendre, il faut que vous soyez meilleur en maths que moi ….. "]
[null,"parce que moi je me demande pourquoi si je m'amuse à checker la formule pour des âges déjà donnés (14 et 18)"]
[null,"je n'arrive pas au même résultat que la valeur donnée dans le graphique …."]

{"sheet":"Barres","index":23,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
["Part des populations de 25-64 ans et de 25-34 ans ayant réussi un enseignement secondaire de second cycle (2008)"]
[]
[]
["En %","25-64","25-34"]
["Allemagne",85.3,85.8]
["Australie",69.900000000000006,82.5]
["Espagne",51.2,65]
["Etats-Unis",88.7,88.1]
["Finlande",81.8,90.1]
["France",70,82.9]
["Hongrie",79.7,85.6]
["Italie",53.3,68.900000000000006]
["OCDE (moyenne)",71.099999999999994,80]
["Pays-Bas",73.3,82.4]
["Royaume-Uni",69.599999999999994,46.6]
["Suède",85,91.2]
[]
["Repères"]
["Ajouter les étiquettes de données"]
["Supprimer le quadrillage"]
["Supprimer l'axe horizontal"]
["Appliquer une couleur spéciale pour la France et OCDE"]

{"sheet":"Aires","index":24,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["Taux d'accès au niveau baccalauréat"]
[]
["En %","Bac \ngénéral","Bac \ntechnologique","Bac \nprofessionnel"]
[1985,22,{"$f":"38-22","v":16},null,null,"source : Ministère Education Nationale "]
[1986,23,{"$f":"40-23","v":17},null,null,"distribué aux parents d'élèves"]
[1987,24,{"$f":"42-24","v":18},1,null,"aux environs des années 2004"]
[1988,26,{"$f":"45-26","v":19},2]
[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,null,"source : INSEE - Internet le 23.10.2013"]
[2001,33.9,21.1,14.2]
[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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Repères"]
["Graphiques en aires empilées (no 2)"]
["Bouton SELECTIONNER DES DONNEES",null,null,null,null,2016]
["Valeurs axes abscisses non trouvées - donc à ajouter",null,null,null,"<==","parfois la compréhension passe tout droit et est bonne !"]
["Série créée pour \"en %\" - donc à supprimer"]
["Etiquettes axes abscisses à aligner verticalement"]
["Axe vertical : impossible d'afficher 20% car la donnée source devrait afficher 0.2 ! "]

{"sheet":"Nuages de points","index":25,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
["Profitabilité",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]
[]
["Graphique standard dont les données X sont lues de façon linéaire. Donc Faux !"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Attention : "]
["Excel prend la Profitabilité comme série - donc la supprimer"]
["Excel ne lit pas les étiquettes des abscisses (x)"]
[]
["Graphique NUAGES DE POINTS - Les données ne sont pas linéaires. Représentation correcte"]
[null,null,null,null,null,null,null,"2016  ==> les suggestions incluent d'office un graphique avec les séries en lissage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Attention : "]
["Choisir le type no 2 ou 4 (séries lissées ou non mais les deux avec marqueurs)"]
["Il faut ajuster  l'échelle :  max à 2048 - intervalle à 256"]
["Attention : ne pas saisir 64K , 128K dans les cellules, sinon l'axe sera obligatoirement linéaire"]
[]
[]
["Spécial : alternative au nuage de points lorsque les données source ne sont pas linéaires"]
[]
["Ventes","2014-01-01","2014-06-01","2014-08-01"]
["Produit 1",16894,18854,23000]
["Produit 2",20210,19632,25784]
["Produit 3",18052,21135,22458]
["Produit 4",16000,20456,24182]
[]
["Histogrammes automatique"]
[]
[null,null,null,null,null,null,"Nuage de points automatique - avec lignes et marqueurs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Double-clic sur l'axe et dans le panneau de format : le Type d'axe est sur automatique. "]
["Essayez dates : résultat identique",null,null,null,null,null,null,"Pour un graphique en nuage de points, rien à faire"]
[null,null,null,null,null,null,null,"La boîte de dialogue n'offre pas la possibilité de changer le type de l'axe"]
["Si vous souhaitez ôter les \"trous\" : passer le Type d'axe sur Texte",null,null,null,null,null,null,"Ce qui est normal, c'est le but d'un nuage de points …"]

{"sheet":"Population Suisse","index":26,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["Données arrondies pour toute la Suisse (sauf les 3 derniers)"]
["Année","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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dans ce cas, le choix du nuage de points est une obligation !"]
["En effet les intervalles entre les années ne sont pas de 1"]
["(et de plus, Excel ne comprend pas l'année 1800 …)"]
[]
["Astuces"]
["S'assurer de choisir un type de graphique affichant les marqueurs : pour que les intervalles entre les années soient bien visibles"]
["Comme d'habitude : si nécessaire supprimer la série inutile des années et pointer correctement sur les cellules des années pour l'axe X"]
["Travailler sur l'axe X : minimum (1800), maximum (2015), intervalle (10)     - Etiquettes au-dessus "]
["Aligner les étiquettes en vertical"]
["Ajouter les étiquettes de données pour la série mais ne prendre que les années  (Valeur X) et garder bien sûr les lignes de d'étiquettes"]
["Déplacer les 3-4 dernières qui \"collent\" trop"]

{"sheet":"Taux de fertilité","index":27,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Autre exemple pour nuage de points"]
[]
[null,null,null,null,"Graphique en courbes sur sélection (en vert) : la catastrophe !",null,null,null,null,null,"Graphique en nuages de points sur sélection (en vert)"]
["Pays","Taux fertilité \n(non réel !)","% femmes entre 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,"Il ne devrait y avoir qu'une série : % femmes",null,null,null,null,null,"Cette fois la compréhension est correcte. Il suffit de retravailler l'axe des "]
[null,null,null,"et l'axe horizontal devrait afficher les valeur du taux de fertilité en ordre croissant",null,null,null,null,null,"abscisses au niveau de l'échelle (min : 0.9 - max : 2, intervalle : 0.1)"]
[null,null,null,"On peut bien supprimer la série Taux fertilité et redéfinir les étiquettes de l'axe"]
[null,null,null,"horizontal mais oups : pas d'ordre croissant et pas de modif ….",null,null,null,null,null,"Nouveau depuis 2013 : les étiquettes peuvent pointer vers des cellules libres"]
[]
["Si les données sont présentées dans cet ordre là, impossible de simplement ",null,null,null,null,null,null,null,null,"Clic sur la série et petit plus ELEMENTS DE GRAPHIQUE"]
["sélectionner les données.Il faut alors créer le graphique manuellement à neuf"]
[]
["Pays","% femmes entre 15-64","Taux fertilité \n(non réel !)"]
["A",42,1.2]
["BE",38,1.5]
["CH",35,1.2]
["D",38,1.1000000000000001]
["DK",51,1.7]
["FIN",54,2]
["FR",45,1.3]
["GR",47,1.5]
["IT",32,1]
["NL",22,1.2]

{"sheet":"Camembert spécial","index":28,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Ventes","Année 2020"]
["Office 2019",900]
["Office 2016 abo",300,null,"Note : les séries à regrouper doivent toujours être les dernières !!!!!"]
["Office 2016 licence",100]
["Publisher",20]
["Ms Project",15]
["Adobe Acrobat DC",13]
["Divers",10]
[]
["Astuces"]
["Choisir directement le type voulu dans la galeire des types de graphique"]
["Ajouter les étiquettes de données (categorie et pourcentage) - garder les lignes d'étiquettes "]
["Dans la boîte de format - catégorie OPTIONS DES SERIES - s'assurer que le second tracé contient les 4 dernières valeurs"]
["Ôter la légende"]
["Si nécessaire : agrandir la zone de traçage"]

{"sheet":"Histo et valeurs négatives","index":29,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
["Moyennes annuelles de températures - 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,"Par défaut avec un minimum"]
["Québec",9,-1,"de modifs (étiquettes en vertical"]
["Montréal",10.9,1.2,"quadrillage, légende, titre …"]
["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,"Pour que les étiquettes soient "]
[null,null,null,null,null,null,null,"APRES la dernière valeur négative ?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Axe avec les petites barres à rendre invisible ?"]
[null,null,null,null,null,null,null,"Boîte de dialogue de l'axe X"]
[null,null,null,null,null,null,null,"Options d'axe"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Traits verticaux",null,"simple quadrillage !"]

{"sheet":"Radar","index":30,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["Analyse comparative","Prix","Qualité","Design","Options","Service\naprès-vente"]
["produit A - le nôtre",80,90,50,60,90]
["produit B - concurrence",100,80,70,80,70]
[]
["Les chiffres d'analyse peuvent par exemple provenir de tests internes, questionnaires au client … "]
["Les réponses sont des rapports sur une échelle de valeurs, des pourcentages par exemple."]
[]
["Note : les données pourraient aussi être des analyses de compétences, de QI etc…."]
[]
["Analyse : ","le graphique permettra de voir que par exemple nous sommes meilleurs au niveau du prix "]
[null,"mais que nous devons améliorer nettement notre design et les options du produit etc….."]
[]
[null,null,null,null,null,"Axe : en anglais aucun problème à afficher la ligne, elle l'est par défaut à la création"]
[null,null,null,null,null,"pas en français et je n'arrive pas à l'afficher"]
[null,null,null,null,null,"en anglais juste bizarre pour faire sortir les graduations"]
[null,null,null,null,null,"(secondaire à 10 - pas de graduation sur principal)"]
[null,null,null,null,null,"????"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Astuces"]
["Type Radar no 2 (avec marqueurs)"]
["Ôter le quadrillage (sinon les graduations principales ne s'affichent pas)"]

{"sheet":"Boursier","index":31,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,0,27,4],[28,0,28,4]]}
[]
["Date","Min","Max","Clôture",null,null,"Productivité portuaire"]
["2001-04-03",55.25,56.375,55.625]
["2001-04-04",54.125,56,55.5,null,null,"Mouvements containers","Min","Max","Moyenne"]
["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}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Attention : si Excel affiche une boîte de dialogue vous demandant de contrôler l'ordre des données, cela signifie que vos données ne conviennent pas pour ce type de graphique. C'est par exemple le cas si vous choisissez ici le no 2 (car il faut 4 valeurs et non 3). Il faut choisir le type 1"]
[]
[]
[]
[]
[]
[]
[]
["Par défaut les marqueurs sont petits et rectangulaires. Ils ont été modifiés\nSélectionner la série : ici CLOTURE et MOYENNE\nBouton POT DE PEINTURE - dessous section MARQUE"]

{"sheet":"Bulles","index":32,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Info : en 2016 les graphiques à bulles se trouvent dans la section NUAGES DE POINTS"]
["Société","Nbre de produits","Ventes","Parts de marché  %"]
["Société A",10,80000,25]
["Société B",12,60000,20]
["Société C",3,90000,30]
["Société D",25,30000,10]
[null,"Taille","Y","X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Astuces"]
["Même si vous sélectionnez correctement la plage source, Excel est perdu à 300% !"]
["Sélectionnez donc une plage de cellules quelconque, juste pour pouvoir créer le graphique"]
["Puis clic sur le bouton SELECTIONNER DES DONNES et tout supprimer"]
["Puis clic sur le bouton AJOUTER "]
["Construire manuellement la série en indiquant les données source X, Y et taille"]

{"sheet":"Nuage-bulles - 2 dimensions","index":33,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"France","Italie","Suisse"]
["Puissance",2,4,6]
["Individualité",5,10,15]
[]
["Nuages de points",null,null,null,null,"Bulles"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Créer un graphique en nuage de points - puis bouton SELECTIONNER DES",null,null,null,null,"Créer un graphique à buller puis bouton SELECTIONNER DES DONNEES et tout supprimer"]
["DONNEES et tout supprimer",null,null,null,null,"Clic sur le bouton AJOUTER et créer une série pour chaque pays"]
["Clic sur le bouton AJOUTER et créer une série pour chaque pays",null,null,null,null,null,null,"Puissance est la valeur X"]
[null,"Puissance est la valeur X",null,null,null,null,null,"Individualité est la valeur Y"]
[null,"Individualité est la valeur Y",null,null,null,null,null,"Ne rien toucher pour taille : ={1}"]
[null,null,null,null,null,null,null,null,"cela signifie que l'on pourrait ajouter une troisième valeur"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ajouter l'étiquette de données pour chaque pays"]
["Sélectionner le marqueur pour choisir ou modifier son type",null,null,null,null,"Ajouter l'étiquette de données pour chaque pays"]

{"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,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Series : chaque bulle est une série à 3 valeurs",null,null,null,null,null,"Representer le risque par un dégradé de couleur : remplissage dégradà à 3 couleurs (1 = vert - 2 = orange - 3 = rouge). Choisir la direction et travailler sur les 3 points"]
["Textes et flèches le long des axes"]
["100% manuel"]

{"sheet":"Sparkline","index":36,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Graphique sparkline = mini graphique dans une cellule"]
[]
["Travailleurs saisonniers en plus"]
[]
[null,"Commerce","Agriculture","Tourisme"]
["Janvier",0.02,0.01,0.01]
["Février",0.02,0.01,0.01]
["Mars",0.02,0.01,0.01]
["Avril",0.02,0.01,0.01]
["Mai",0.02,0.1,0.05]
["Juin",0.02,0.12,0.08]
["Juillet",0.04,0.15,0.15]
["Août",0.04,0.2,0.15]
["Septembre",0.02,0.15,0.08]
["Octobre",0.02,0.1,0.01]
["Novembre",0.08,0.01,0.01]
["Décembre",0.1,0.01,0.1]
[]
[]
[]
["Sparkline"]

{"sheet":"Formes dessinées ","index":37,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Pluie : moyennes pour Juillet"]
["EUROPE","Nombre de jours"]
["Amsterdam",10]
["Athènes",1]
["Barcelone",5]
["Berlin",9]
["Dublin",13]
["Genève",9]
["Istanbul",3]
["Lisbonne",3]
["Madrid",3]
["Moscou",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienne",9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Petits trucs"]
["Positionner","ALT plus glisser  = suivre les cellules sous-jacentes"]
["Forme parfaite","Maintenir la touche de majuscule (MAJ ou SHIFT)"]
["Ancrage de la forme","Selon l'objet actif : sur le graphique ==> dans le graphique / cellule active dans la feuille ==> libre"]
["Visage","Souriant = par défaut / il faut faire glisser le petit losange pour transformer le sourire. "]
[null,"Astuce : zoomer sinon on n'arrive pas à attraper le losange jaune"]

{"sheet":"Formes dessinées - A faire","index":38,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Pluie : moyennes pour Juillet"]
["EUROPE","Nombre de jours"]
["Amsterdam",10]
["Athènes",1]
["Barcelone",5]
["Berlin",9]
["Dublin",13]
["Genève",9]
["Istanbul",3]
["Lisbonne",3]
["Madrid",3]
["Moscou",12]
["Paris",11]
["Prague",10]
["Rome",2]
["Stockholm",9]
["Vienne",9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Petits trucs"]
["Positionner","ALT plus glisser  = suivre les cellules sous-jacentes"]
["Forme parfaite","Maintenir la touche de majuscule (MAJ ou SHIFT)"]
["Ancrage de la forme","Selon l'objet actif : sur le graphique ==> dans le graphique / cellule active dans la feuille ==> libre"]
["Visage","Souriant = par défaut / il faut faire glisser le petit losange pour transformer le sourire. "]
[null,"Astuce : zoomer sinon on n'arrive pas à attraper le losange jaune"]

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

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