Đã hoàn thành

Create Excel Pivot Table and Chart

I have raw data that I get from our phone system. I would like to be able to display it to show the number of inbound calls we get each week. I think the correct way to do this is with a Pivot Table, but it doesn’t have to be done that way. The resulting Excel file will be one where I can use the “Change Data Source” and point it to any of the output files from our phone system and have it generate the table and chart shown as a sample screenshot attached. It does not have to be EXACTLY like my example, but this is the information I want to show.

NOTES ABOUT THE DESIRED EXCEL TABLE AND CHART (see [url removed, login to view]):

-The parts highlighted in Red must be included, I don’t care if the other columns are there or not.

-The data source may be one day or it may be a few years worth of data, the Excel table/chart that you build must be able to react properly to any quantity of data. You can set a limit of 3 years if that helps.

-For this purpose of this, weeks ENDS on Sunday. I have looked at the WEEKNUM function in Excel and this is possible.

-Even if a week has less than a full week’s of days, it should still be shown.

-Please use the week ending date on the chart’s X axis as I have shown in the screen shot (not week numbers).

-Weeks should be sorted Oldest to Newest (top to bottom in the table) and (Left to Right in the chart).

-Please include a trend line (shown in light blue on my sample).

NOTES ABOUT THE DATA FILES:

-FORMAT: They come from the phone system as CSV files. I would prefer to use them as CSV, but it doesn’t seem that Pivot Tables can use CSVs as a data source. If you can make it work with CSVs that is great, but if not, you can assume that I will open the CSV and save it as an XLSX. I will not make any other changes to the source data.

-FILTER: Only include records/rows that have they “Type” (column C) is equal to “Inbound Call”. If they are blank or say something else, do NOT include that row.

-FILTER: You should only include records/rows were the “Minutes” (column B) is greater than “1” (do not include 1).

-SAMPLES: I have attached 3 sample data files. One with 3 days of data, one with 2 months of data and one with 12 months of data. I have left these in the CSV format.

END.

Kĩ năng: Excel

Xem nhiều hơn: excel create pie chart table demonstrates percentage class received letter gradetable create pie chartpercentages stated pie cha, vsto excel create pivot table vbnet, vsto excel create table, excel create dynamic chart, excel table pivot, create pivot excel, create pivot table dynamically excel, excel create chart csv file, excel 2007 table pivot table, excel create pivot table, excel create table, pivot excel table, create chart csv file excel, create pivot excel net, net sql server table write excel pivot

Về Bên Thuê:
( 33 nhận xét ) Southeast, United States

ID dự án: #13428483

Được trao cho:

jmtamez2203

Hi there - My name is Manuel. I’ve read your brief and can see that you’d like to have an Excel file to analyze inbound calls. I am new in Freelancing, but I have more than 10 years designing Excel for data analysis on Thêm

$28 USD trong 1 ngày
(1 Nhận xét)
0.9

42 freelancer đang chào giá trung bình $44 cho công việc này

$200 USD trong 2 ngày
(249 Nhận xét)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Thêm

$50 USD trong 1 ngày
(212 Nhận xét)
7.3
sandroshubladze

Hi I am Excel Expert and VBA Programmer (for macros) I can create for you desirable worksheet If interested, contact me Thanks & Regards

$100 USD trong 1 ngày
(159 Nhận xét)
6.9
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD trong 1 ngày
(230 Nhận xét)
6.9
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Thêm

$35 USD trong 1 ngày
(134 Nhận xét)
6.4
$70 USD trong 1 ngày
(117 Nhận xét)
5.7
$20 USD trong 1 ngày
(48 Nhận xét)
5.4
satishtl

- Went through the csv and the images.... - Can be done like this. You specify the folder where the csv files are, and have the duration entered ie start date and end date.... - Based on the period the chart can be p Thêm

$100 USD trong 4 ngày
(39 Nhận xét)
5.2
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I handle microsoft excel very well and I can do this for you. I handle pivot tables and charts. Please contact me by chat Thêm

$25 USD trong 3 ngày
(74 Nhận xét)
5.0
$333 USD trong 7 ngày
(13 Nhận xét)
4.9
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I ha Thêm

$50 USD trong 3 ngày
(44 Nhận xét)
4.5
jaydeepniper2011

A proposal has not yet been provided

$30 USD trong 1 ngày
(17 Nhận xét)
4.2
EngrShahidul

I am much experience in Excel and SPSS data analysis, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. I have Thêm

$55 USD trong 1 ngày
(15 Nhận xét)
4.2
fb57e1f6608abfb

I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Thêm

$30 USD trong 0 ngày
(7 Nhận xét)
3.5
$30 USD trong 1 ngày
(10 Nhận xét)
3.7
scorpionobaid01

Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Thêm

$20 USD trong 0 ngày
(12 Nhận xét)
3.7
anachirilov7

Hello! Please send to me more details about this project and i'm ready to start work right now. Select me please.

$30 USD trong 1 ngày
(8 Nhận xét)
3.8
$35 USD trong 3 ngày
(2 Nhận xét)
3.7
bluefox4ever

Dear Hiring Manager, I want to do your job/project now, let's start immediately. I have read the job description. I've been working in a BPO company for more than 13 years now. My job there honed my skills to be Thêm

$35 USD trong 7 ngày
(9 Nhận xét)
3.4
$50 USD trong 1 ngày
(2 Nhận xét)
3.7