How to assign specific colours to bars on a variable width bar chart.

[Ernie8888]

The spreadsheet has a table of product names, suppliers names and product prices and volume/quantity supplied. A prices change a macro is used to sort the table in price order. The result is the copied into a table used us generate a variable width bar chart where product quantity is represented by bar width and bar height is the price. I am able to produce the graph. What i would like to do is have the bars for each supplier the same colour. I imagine the colours would be assigned according the a supplier colour code table