Færdiggjort

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.

Evner: Excel, Data Analysis

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Amsterdam, Romania

Projekt ID: #20373144

Tildelt til:

olegsamsonov

⭐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 på 1 dag
(1 bedømmelse)
1.4

7 freelancere byder i gennemsnit $35 på dette job

TonmoyRoy111

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 på 1 dag
(310 bedømmelser)
6.8
$25 USD på 1 dag
(48 bedømmelser)
5.4
monoar3

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 dage
(0 bedømmelser)
0.0
farazageek

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 Flere

$20 USD på 1 dag
(0 bedømmelser)
0.0
cantoker

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 dage
(0 bedømmelser)
0.0
Untouchhabib

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 Flere

$20 USD in 6 dage
(0 bedømmelser)
0.0