Voir la source de Tableau croisé dynamique - Excel

{{Tuto Details
|Main_Picture=Ligne_des_totaux_tableau_-_Excel_Microsoft_Excel_2013-2019_logo.svg_1_.png
|Main_Picture_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":46,"top":1,"width":587,"height":555,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.81,"scaleY":0.81,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/1/15/Ligne_des_totaux_tableau_-_Excel_Microsoft_Excel_2013-2019_logo.svg_1_.png","filters":[]}],"height":450.14807502467914,"width":600}
|Description=Dans ce tutoriel, vous apprendrez à créer un tableau dynamique sur Excel 2016
|Categories=Numérique
|Public=Professionnels, Grand public, Médiateurs
|Type de contenu=Fiche action
|Difficulty=Hard
|Licence=CC-BY
}}
{{Introduction
|Introduction== Conseils et astuces sur le format des données =

* Utilisez des données propres et tabulaires pour obtenir les meilleurs résultats.
* Organisez vos données en colonnes, et non en lignes.
* Assurez-vous que toutes les colonnes ont des en-têtes

<br />

* Mettez en forme vos données en tant que [https://support.microsoft.com/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c tableau Excel] (sélectionnez vos données, puis cliquez sur Mettre sous forme de tableau dans le rubeau) cf : [https://rennesmetropole.dokit.app/wiki/Cr%C3%A9er_un_tableau_-_Excel tutoriel Créer un tableau]

<br />
}}
{{Materials
|Prerequisites={{Prerequisites
|Prerequisites=Créer un tableau - Excel
}}
}}
{{Tuto Step
|Step_Title=Création Tableau dynamqiue
|Step_Content=Cliquez dans votre tableau pour faire apparaître l'onglet '''"Création"'''

<br />

# Cliquez sur l'onglet "'''Création'''" 
# Cliquez sur le bouton "Tableau dynamique"
|Step_Picture_00=Tableau_crois__dynamique_-_Excel_Capture_d_cran_2025-05-20_151154.png
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.17,"width":1422,"height":978,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.42,"scaleY":0.42,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/0/07/Tableau_crois_dynamique_-_Excel_Capture_d_cran_2025-05-20_151154.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":320.38,"top":19.8,"width":46.28,"height":26.18,"fill":"rgba(255,0,0,0)","stroke":"#FF9103","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":111.1,"top":44.38,"width":72.83,"height":40.98,"fill":"rgba(255,0,0,0)","stroke":"#FF9103","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":413,"width":600}
}}
{{Tuto Step
|Step_Content=Cela crée un tableau croisé dynamique basé sur le tableau existant. 

<br />

# Sélectionnez '''OK'''.

<br />
|Step_Picture_00=Tableau_crois__dynamique_-_Excel_Capture_d_cran_2025-05-20_151523.png
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.17,"width":403,"height":343,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1.49,"scaleY":1.49,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/1/15/Tableau_crois_dynamique_-_Excel_Capture_d_cran_2025-05-20_151523.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":409.84,"top":486.37,"width":119.32,"height":39.07,"fill":"rgba(255,0,0,0)","stroke":"#FF9103","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":511,"width":600}
}}
{{Tuto Step
|Step_Title=Champs de tableau croisé dynamique
|Step_Content=Pour ajouter un champs dans le tableau croisé dynamique : 


Faire glisser les champs (1) dans les zones du tableau (2) 

<br />
|Step_Picture_00=Tableau_crois__dynamique_-_Excel_Capture_d_cran_2025-05-20_151725.png
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":-0.01,"width":1919,"height":854,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.31,"scaleY":0.31,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/f/fe/Tableau_crois_dynamique_-_Excel_Capture_d_cran_2025-05-20_151725.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":535.34,"top":96,"width":122.28,"height":100,"fill":"rgba(255,0,0,0)","stroke":"#FF9103","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0},{"type":"wfnumberedbullet","version":"3.5.0","originX":"left","originY":"top","left":444,"top":83,"width":25,"height":25,"fill":"rgb(0,0,0)","stroke":"#FF9103","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"objects":[{"type":"circle","version":"3.5.0","originX":"center","originY":"center","left":0,"top":0,"width":24,"height":24,"fill":"#FF9103","stroke":null,"strokeWidth":1,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":12,"startAngle":0,"endAngle":6.283185307179586},{"type":"text","version":"3.5.0","originX":"center","originY":"center","left":0,"top":0,"width":7.79,"height":15.82,"fill":"rgba(0,0,0,255)","stroke":null,"strokeWidth":1,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"text":"1","fontSize":14,"fontWeight":"normal","fontFamily":"arial","fontStyle":"normal","lineHeight":1.16,"underline":false,"overline":false,"linethrough":false,"textAlign":"left","textBackgroundColor":"","charSpacing":0,"styles":{} }],"number":1},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":536.88,"top":205,"width":129.23,"height":100,"fill":"rgba(255,0,0,0)","stroke":"#FF9103","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0},{"type":"wfnumberedbullet","version":"3.5.0","originX":"left","originY":"top","left":438,"top":183,"width":25,"height":25,"fill":"rgb(0,0,0)","stroke":"#FF9103","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"objects":[{"type":"circle","version":"3.5.0","originX":"center","originY":"center","left":0,"top":0,"width":24,"height":24,"fill":"#FF9103","stroke":null,"strokeWidth":1,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":12,"startAngle":0,"endAngle":6.283185307179586},{"type":"text","version":"3.5.0","originX":"center","originY":"center","left":0,"top":0,"width":7.79,"height":15.82,"fill":"rgba(0,0,0,255)","stroke":null,"strokeWidth":1,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"text":"2","fontSize":14,"fontWeight":"normal","fontFamily":"arial","fontStyle":"normal","lineHeight":1.16,"underline":false,"overline":false,"linethrough":false,"textAlign":"left","textBackgroundColor":"","charSpacing":0,"styles":{} }],"number":2}],"height":267,"width":600}
}}
{{Tuto Step
|Step_Title=Exemple
|Step_Content=Par exemple ici je souhaite connaître le nombre d'agents par école avec une photo :
|Step_Picture_00=Tableau_crois__dynamique_-_Excel_Capture_d_cran_2025-05-20_152048.png
}}
{{Notes}}
{{PageLang}}
{{Tuto Status
|Complete=Published
}}