Yes, you can use the SORT function to create dynamic charts. By linking the chart data range to a SORT function, the chart will automatically update as the underlying data changes