Creating graph based on highlighted cells

What causes the cells to turn yellow? Will there always be at most 1 yellow cell per row?

If I understand what you are trying to do, I would add a helper column (or columns) to the right of the table that detects the yellow cells and returns the value of the yellow cell to a single column. Then use that column in the line chart. For example, AC might have the values 9; 6; 14; 5; 5 in it. Then AD could be =INDEX(C2:AA2,AC2) (copied down). Then use column AD in the line chart. The difficult part is deciding how best to get the values into column AC.

I think we need a better description of what you want to do. What I was suggesting would essentially recreate columns C:G, so you could essentially create your chart from those columns.

Can you perhaps prepare a small sample file, showing what you have, and manually working out a few examples of what you want, and giving some idea of what the line chart will look like when the analysis is complete.