excel

excel
custom sort updates a to z sort
text function click then mmmm format https://support.office.com/en-us/article/sort-data-using-a-custom-list-cba3d67a-c5cb-406f-9b14-a02205834d72

stop update pivot by disable autosort use dif workbook
rightclick refresh update pivot

i learned the right function getting previous characters in a cell

Unlike a standard chart, you cannot change the chart data range in a PivotChart's Select Data Source dialog box.

trendlines, data labels, error bars, and other changes to data sets are not preserved.

condense more categories in filters and search them
but cannot link to multiple pivots tables like slicers
slicers affect other slicers
filter -->keep only  selected items
value filters greater than
label filters names ending containing

on chart, then on the Design tab, select Add Chart Element.

You can now add slicers to the sheet.

connect filter to pivot to multiple tables module 40lab

Hint: The Filter Connections option is available on the chart Analyze tab.
Hint: Create your new Pie chart based on another new pivot table that you will create on the Pivot worksheet.