Where is the table button?

  1. Open the sheet containing your data.
  2. Select the range of cells containing your data.
  3. Click on the “Table” button in the top menu bar. The button looks like a grid of cells with a thick border around it.
  4. Choose “Create Table” from the drop-down menu.
  5. In the “Create Table” dialog box, select the “My table has headers” checkbox.
  6. Enter a name for your table in the “Table Name” field.
  7. Click “Create”.


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Under value labels you can choose percentage or amount. I don't think you can show both.

    To include all weeks for the 1st quarter you can sum the data in the sheet and select the totals for your chart. I would do this using a SUMIFS formula.

    If your data looks like this

    You can create a total like this

    Using the formula

    =SUMIFS([Opened Complaints]:[Opened Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)


    =SUMIFS([Closed Complaints]:[Closed Complaints], $[QT Week]:$[QT Week], >=1, $[QT Week]:$[QT Week], <=12)

    where 1 and 12 are the first and last weeks in the quarter.

    Use this data to create your pie chart