Draw line chart based on cell color

[undemane]

In Cell A1, A2, A3, A4, etc, I have test data that is colored Yellow, Blue, etc. In Cell b1, b2, b3, b4, etc., I have the values I want charted as a line chart. But, I want to chart to pick up data in col. B for cells that are colored yellow in Col. A. Without writing any VB Code, is there a way to do this? Thanks

 

[Gerald Higgins]

Hi, it's not really clear to me what you want exactly.

Are you saying some random values in column A will be coloured yellow - let's say A2 and A4 for example, and all others will be coloured blue ?

And you want the chart to show only the data for the yellow ones ?

The only way I can think of doing this (without VBA) is to define what your logic is for colouring certain values yellow, and then writing that logic into a formula which pulls the "yellow" values into a column, and doesn't pull the blue values.