excel - How to extract each color bar and copy them in a table? -

i made diagram show unique columns several colors in each, shown in picture. have hundreds of make , have no idea how that.

i know if it's possible extract each color bar separately , copy them under "icons". not sure if word "extract" correct term, display raw-image of color bar.

maybe formula?

i able use office excel , libreoffice calc. thank much.

these instructions manually, ideal project apply vba , automate these tasks.

the idea create each category of stacked bar own individual chart, can exported or copied image file.

this based on "spark lines" concept, small, eye-catching graphics embedded within text of document, opposed large graphics. ms added sparklines functionality in recent versions of office apps, , although ms "spark lines" doesn't support stacked bar chart type, same thing can still accomplished little work.

step 1: select 1 row of data , insert chart, stacked bar.

step 2: select data , switch rows & columns.

step 3: delete gridlines, axes, chart border, etc., .

step 4: expand plot area covers entire chart area, , format data series 0% gap width.

step 5: apply colors each point in series.

step 6: resize chart fit on cell.

finally have created chartobjects can manipulate them. chartobjects can exported image files, or copy/paste-special images, bmp, or enhanced metafiles, etc.