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.


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.

Skills: Excel, Data Analysis

See more: format excel data, excel vba chart show data table, mssql 2005 import excel data table, how to add a trendline to a bar graph in excel, excel trendline equation, custom trendline excel, how to add a trendline in excel 2016, how to add a trendline in excel 2017, how to create a trend chart in excel 2013, why can't i add a trendline in excel, trend chart in excel, automatically format excel data word template, lock format excel pivot table refresh, open xml excel data table template csharp, excel 2010 line chart pivot table, excel line chart csv data, excel data table, excel data table lookup, excel data table example, excel data table not working

About the Employer:
( 0 reviews ) Amsterdam, Romania

Project ID: #20373144

Awarded to:


⭐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

$30 USD in 1 day
(1 Review)

7 freelancers are bidding on average $35 for this job


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

$100 USD in 1 day
(310 Reviews)
$25 USD in 1 day
(48 Reviews)

i am a very good data [login to view URL] speed is good. you can depend on me. i shall complete the project on time.

$24 USD in 5 days
(0 Reviews)

My name is Faraz Ahmad and I am a professional virtual assistant who specializes in MS Excel. I am interested in doing this Excel chart work without harming the data for you and I can complete 100% of this work for yo More

$20 USD in 1 day
(0 Reviews)

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.

$25 USD in 7 days
(0 Reviews)

Trustworthy Graphics Designer, Illustrator, logo design, data entry or data processing with five years experience. Also have experience Senior Office Executive of Megna Group here hare I’m helping company Clean and en More

$20 USD in 6 days
(0 Reviews)