0

I would like to make a graph that graphs the total number of incidents each child gets into each day, but also make it so as this table is updated with more inputs, the graph will automatically update based on the new data.

enter image description here

Currently make a pivot table has seemed most promising, however the automatic updating is still stumping

enter image description here

2
  • 1
    Convert source range to "smart table".
    – Akina
    Jul 26, 2019 at 6:15
  • Create Dynamic Named Range to create the Chart, Excel will always take care of new data as well modification too!! Jul 26, 2019 at 7:05

1 Answer 1

0

The Pivot Tables in Excel, work better when the source is a Table.

Please follow the following steps to convert the data into a table.

  1. Select all the cells that you have data in (From the image it looks like "A1:D11").
  2. In the Home tab in the ribbon, select Format as table and choose a style. Or Alternatively, you can use CTRL+T as a shortcut to create a table.
  3. In the create table window, make sure you choose "My table has headers" and click OK.

Following the above steps converts the data into a Table.

Now when you click on any of the cells in the table and Insert Pivot table from the Insert tab, the table will be selected as the source for the PivotTable. And whenever you add data at the row below the last row of the table and hit enter, the Table will automatically expand. After that, you can simply refresh the PivotTable.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .