ExcelBanter - Name change with filtered column

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Name change with filtered column (https://www.excelbanter.com/charts-charting-excel/161932-name-change-filtered-column.html)

BillO

Name change with filtered column

Hi, I have a column of data for times, and another with shift (A,B,C,D) I
also have a chart which is a plot of the times, I filter this and select A,
how do I have the name for the plot change to the appropriate shift when
filtering.

thanks

All times are GMT +1. The time now is 05:26 PM.