Column chart: Assign/derive column colors by/from data values

[Dmitry_D_Onishchenko]

Hi, I have a very basic question about plotting data in Excel charts.

My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and columns' color defined by the corresponding category value. The two requirements are:
a) there should be no clustering, stacking or grouping of columns; just a 'group' role should be assigned to QTTY column to control the bar color (which I don't know how to implement);
b) user should have direct access to nominating a color to a category (i.e., once a new category appears in data, Excel should not re-assign all the colors but instead look for 1-1 correspondence between categories and colors OR select a new color for the new category while retaining old colors for old categories).

What chart type should I use?

Thanks in advance,
Dmitry

***
Sample data:

DT	CAT	QTTY
2019-05-28	A	-100
2019-05-28	B	200
2019-05-29	B	-50
2019-05-30	C	200
2019-05-30	A	100
2019-05-31	A	-150