Create a chart according to the colors of cells

[elektor]

A simple question (difficult for me). How can I create a chart according to the colors of cells?

 

[asking]

Try ~

Do your graph as normal, then highlight your headers, click the filter icon in the data menu and then filter by colour on which ever column has the colours.

When filtered by the colour, your graph will change to reflect the values that are visible.