Format Excel data table to fit a trend/line chart

Attached you'll find a correlation data table from where I'd like to perform a trend analysis. A line chart will be meaningful for this purpose and here I'd need your help: Format existing data table of 600 rows/3 columns so it will fit a trend/line chart Sort 'Name 1' column into 24 pairs and apply a 24 line chart out of it Sort further the 'Name 1' into 8 currencies and apply an 8 lines chart out of it. Basically two distinct line charts are needed one with 24 lines and other with 8 lines Each line in the line chart will bear a value number when mouse over. Print out that actual value and make it appear as a chart legend: pair/currency, line color and its numeric value...I want to apply some alerts when reach certain threshold, later on. Functionality is important so keep it simple please. Background: Please note that is a Query & Connection associated with the data table that are replicating every minute or so. The 'Description' column variable (the only variable) is the correlation value between Name 1 & Name 2. FYI: Applying a bar chart to Name 1, Description, Name 2 does dot change the outcome when switching from Name 1 to Name 2 therefor I assume you may discard column Name 2 when creating the line charts, if you consider so.