How to Create an Interactive Dashboard in Excel | Scribe

    How to Create an Interactive Dashboard in Excel

    • Emma Chieppor |
    • 28 steps |
    • 4 minutes
      1
      Click "Insert"
      2
      Click "PivotChart"
      3
      Click "Existing Worksheet"
      4
      Click here
      5
      Click "2"
      6
      Click "A16"
      7
      Click "OK"
      8
      Drag "Sales" to the Values area
      9
      Drag "Items Sold" to the Axis area
      10
      Drag "Years" to the Legend area
      11
      Click "Close pane"
      12
      Select rows 28 through 35
      13
      Right click "33"
      14
      Click "Hide"
      15
      Select the chart
      16
      Click "PivotChart Analyze"
      17
      Click "Insert Slicer..."
      18
      Click "Representative"
      19
      Click "OK"
      20
      Reposition Slicers