Create a PIE Chart, counting how many entries you have for one column

Create a PIE Chart, counting how many entries you have for one column
=COUNTIFS(Data!L:L,B4)Name of the sheet: Datacolumn: LB4: The text(assigned group) you want to count.

Create a new Macro to refresh the Excel data

Create a new Macro and paste the below command

Sub Update()
'
' Update Macro
'

'
Range("A6").Select
ActiveWorkbook.RefreshAll
End Sub

Click on the Insert tab and select 'button'


Click anywhere in the Spreadsheet
You will get the below prompt, click on update to use the Macro you just created and click on ok

Now you are ready to use your Macro refresh button!