Completed

Building chart from data- on excel or another user friendly application

Hello! We are providing analytic services to worldwide exhibition centers. They have yearly 4 campaigns. It takes around 20 days. Our task is to measure how these dates affect the number of visitors. We have historical 5-10 years data. Let me describe you how we creating chart manually right now.

Assuming that we have 6 years daily numbers and 24 (4x6years) campaign dates ( date-last date of campaign/offer)

1. Manually finding and marking 24 campaign dates on historical data file ( excel).

2. Selecting last 20 days of the campaign on every season ( 4 column data per year ) & copy to a new tab.

[login to view URL] the average number of visitors on last 20 days.

4. Finding the number of deflection-lapse from average on every last 20 day.

5. Applying these to whole last 6 years and finding the average deflection-total 24 column.

6. According to the data creating excel chart.

Please see the attached sample step by step.

We will need data by season, and last 20 days also may change. Please make is variable.

Our final goal to see the visual excel chart.

What I need is macros or basic application, when I give raw data and dates on 1st step to get final chart on step 6

Dear All, It seems attachment is not visible, I had attached again.
Additionally, I had uploaded one sample raw date for you to work on it provide me the final chart to award the winner.
Thank You.

Dear all, thank you for time. I had very little correct feedback. tomorrow morning ( GMT + 4 ) I will award the winner. Thank you your patientce

Skills: Charts, Data Analytics, Data Processing, Excel, Excel Macros

See more: friendly freelance web designer with 10 years experience, export data excel net desktop application, export data excel net standalone application, move data excel web application, excel chart data csv file, create user friendly front end excel, j2ee application import data excel oracle, change chart data vba excel, chart data excel vba, convert word data excel chart, excel vba chart data, chart csv data excel, displaying real time data excel window application, chart dynamic excel cell time stock data, excel chart data dynamic 2003, excel macro next chart data

About the Employer:
( 7 reviews ) Baku, Azerbaijan

Project ID: #15981704

Awarded to:

DataHome

Hello there Excel experts here with 10 years track records. I didnt see any attachment on the project Can you re-send here ? By the look of your requirement, I hope i can do it for low cost Waiting.. Amaan

$120 USD in 1 day
(43 Reviews)
8.1

19 freelancers are bidding on average $137 for this job

jaylancer43

Hello Sir, My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If More

$210 USD in 3 days
(606 Reviews)
8.3
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. Roy

$150 USD in 3 days
(255 Reviews)
6.4
$155 USD in 3 days
(51 Reviews)
6.2
caabdul

Hi there, consider the job done with perfection. Thanks

$40 USD in 10 days
(54 Reviews)
5.9
FirstChoiceWeb

Hello, We have reviews the project [login to view URL] have a lot of experience of data scraping and data entry. We can do this job very. We have done plenty of similar jobs in the past successfully. We can do this job with More

$50 USD in 3 days
(56 Reviews)
5.9
$155 USD in 3 days
(63 Reviews)
6.1
sonarkaushik

I am very able to create this chart and ready to start

$156 USD in 3 days
(52 Reviews)
5.8
SShtv

I have a large and successful practical experience in data visualization and building Dashboards. As an example I give screenshots of some of my works. [login to view URL] More

$120 USD in 2 days
(58 Reviews)
5.6
zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de More

$250 USD in 5 days
(18 Reviews)
5.3
$94 USD in 3 days
(21 Reviews)
4.8
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$120 USD in 2 days
(22 Reviews)
5.0
lamyae88sid

A proposal has not yet been provided

$166 USD in 3 days
(24 Reviews)
5.1
sourabhg98

Hey! This is Sourabh Gupta from New Delhi. Greetings for the first day of the year :) I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with More

$39 USD in 1 day
(81 Reviews)
5.2
$90 USD in 3 days
(34 Reviews)
5.1
rajafaizan

Hi, I read project detail very carefully and i have good command on MS Office like (Excel, Word, VBA, Macro, visual Chat, pivot table). I will create data analysis report and chart as per your requirement. Let's cha More

$183 USD in 4 days
(30 Reviews)
4.5
Ashisjena2015

Hi, I am an expert in advanced excel. So, I will help you on this project. Please discuss in detail now. Price= $100 Time=Immediate

$100 USD in 0 days
(24 Reviews)
4.5
adgotmare

I would like to do your project, expert in multivariate modelling of data, expert in SPSS , Stata and excel

$155 USD in 3 days
(14 Reviews)
4.0
infotechjpm

Hello, We have put a glance to your job details and we are quite interested to do this job. Let us tell about our experience. Since last 6 years we are in graphics design profession. I have more than 6 years ex More

$250 USD in 5 days
(0 Reviews)
0.0