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.
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.
⭐Don't Just Dream Do. with me⭐ I have many experience with excel and excel macro. My job give me a chance with work in excel. I could your job ASAP with your request. Thank you
7 pekerja bebas membida secara purata $35 untuk pekerjaan ini
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
I can turn this data into a meaningful trend analysis table and graph in the excel table for you. Thanks to this process, you will be able to use the table in similar analysis stages.