I need a chart to show 5 sets of data

Before you can even think about analysis, the data need to be put in order. In Excel, it is usually better to "go deep" and to "go wide." The data will have to be "normalized' - that is, in this case, be converted to a format:

Date|Metric|Column A|Value - in any order, actually

Date would be gotten from Row 1
Metric would be gotten from Row 2
Column A (whatever this is) would be gotten from Column A
Value would be gotten from the various cells

This would result in one record per cell (700+ records).

However, once in a normalized format you can "slice and dice" the results with pivot tables into almost any format you can imagine.

It will take VBA to translate the data properly. Maybe someone will jump in before me. Otherwise, I'll put this on the shelf for the "between the holidays" slowdown.

You would probably have to have a "translation" helper column to translate 0.0 to 5.0 into percents. I would also put in another helper column to sort metrics into companies. It might help with analysis later on.

Good luck to you. Regardless of what the new requirement is, keep in mind designing the data in a "normalized" format.