I have a data range that I am charting to show percentage of total of the
various data categories. The problem is there are a lot of categories under
2% I wish to combine into 1 entitled 'Misc'

Does anyone know a way to combine several data points into one.

TIA - Mark