It often seems that the hardest part of some charting/graphing problems is in the spreadsheet layout. IMO, the first step in a problem like this is to extract the desired data from the existing spreadsheet into something more conducive to graphing -- A list of values. I would probably use your observation that there are 5 columns between each result and an INDEX() function to pull the desired values from each mini table into another table that I can use to plot the data.
The other complication you have is that some results are text strings ("99% R") and others are actual values (35%). So, before or after this data extraction step, you will need a step to extract the number from the text string. Maybe something like =VALUE(LEFT(D2,3)). You might need something more complex (I'm not very proficient with Excel's text manipulation functions).
Another thought -- how is this data entered into the spreadsheet originally? By hand? Macro? Other? If you had any control over how this data was entered into the spreadsheet, I would be tempted to tackle this problem at that level. Set up the data into something more like a standard data base instead of this "mini-table" format. In the long run, something that looks more like a database will be easier to work with.
This kind of "database management" is not something I'm very good at, so I'm not sure I can be of much more help.
Bookmarks