Concluído

Excel: Create Charts & Graphs (Make Data Beautiful)

I do not know exactly what I need but I know I want good charts to graphically represent the data in the attached file. As an Excel expert, you will likely see the data and know how to run with it. I do not want to be very hands-on in the process.

I need someone to create a file that I can use to add stats to it monthly for charting. Right now I keep everything in the attached Excel file. My preference would be for Sheet 1 to have the different charts that I can review. Something like a dashboard. The charts need to update automatically as I add new data each month. The data will come from Sheet 2 or some other sheet.

Data is collected once a month. Originally I only stored the Item Name and Quantity (Count). As time went on, I started collecting more data.

As time has passed, more items have been added to the inventory. That is the reason for there being blank values in some locations.

The values I am most interested in Charting are...

Unique

%

Count

I want the Unique and Count values to also show the % of growth over the previous month. If the dashboard allows, allow me to set the option to compare to; Last Month, 3 Months Ago, 6 Months Ago, 12 Months Ago.

Right now there are only 40 Items but this will continue to increase (likely no more than 50).

If you ask questions, do not be too technical.

My goal is to quickly find someone that can do this and allow them to run with it without being asked a lot of questions.

FYI - The values I have provided "Item 1, Item 2" are not the real values. I am unable to share the real name of the values but once the file is in my possession, I'll revise it. So whatever your solution is, I need to be able to easily modify the item names.

I only want to hire someone that pay attention to detail. Because of that, I will only consider bids that start with this text "I read the details and reviewed the Excel file". That way I know you read it all.

Habilidades: Excel, Processamento de dados, Visual Basic, Charts, Estatísticas

Veja mais: advanced excel charts and graphs templates, creative excel charts, how to make excel graphs look professional, beautiful excel charts, cool excel charts and graphs, best excel graphs templates, advanced excel charts and graphs, how to make a graph in excel, mysql data php create dynamic graphs, create graphs mysql data, excel create data entry sheet, excel create data sheet, excel create data input macro, create front end enter data excel spreadsheet, create automatic graphs excel visual basic, excel create report data sheets, scheduled updates excel charts graphs, extract data excel create report, make data base excel file website, qtp vba macros excel create test data

Acerca do Empregador:
( 57 comentários ) Lexington, United States

ID do Projeto: #23272060

Concedido a:

SShtv

Hi, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and Mais

$75 USD em 2 dias
(90 Comentários)
6.0

30 freelancers estão ofertando em média $61 para esse trabalho

asin1987

I read the details and reviewed the Excel file Dear Employer, I have read your requirement and I will create the charts, graphs and analysis you are looking for. Please message me to discuss further. Thanks and Rega Mais

$200 USD in 3 dias
(194 Comentários)
7.7
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Mais

$100 USD in 7 dias
(123 Comentários)
7.0
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mais

$111 USD in 3 dias
(142 Comentários)
6.2
rashedkhanrubel

Hi, I have understand the project requirement & interested to make dashboard with nice charts and graph for this project. Please send a message so we can discuss more & start the project. Thanks.

$55 USD em 1 dia
(112 Comentários)
5.7
AnowarRatul

I read the details and Reviewed the Excel file. --------- $ 13 Only ------ In just 3 Hours ------ Excel Chart, Graph, Pivot Table, VBA Macro Coding, Formula Generation and Automation Process Expert with 5 Ratting.----- Mais

$13 USD em 1 dia
(82 Comentários)
5.0
sparkingboy2010

"I read the details and reviewed the Excel file" Hi, there I read the description of the task. It is matching my expertise. I am willing to accomplish it. Please open chat for further discussion thanks

$70 USD em 1 dia
(58 Comentários)
4.8
khanjzthanjzt

Hi I have read and understand the requirement, it’s very much doable and I’m experienced in making pie charts, graphs and mapping in excel. Allow me to complete this work without any error. Warmest Regards https://www. Mais

$75 USD in 3 dias
(10 Comentários)
4.5
dglorifier

I read the details and reviewed the Excel file Hi, I am a Lean Six Sigma professional with two Masters' in electrical engineering. I have years of experience using Excel and I have made some dashboards myself. I am co Mais

$50 USD in 3 dias
(13 Comentários)
4.3
mowachira77

Hi there. I read the details and reviewed the Excel file. I have a 5 years of experience in VBA, charts excel and statistics. I have completed similar work on charts previously and am available to complete your work AS Mais

$43 USD em 1 dia
(16 Comentários)
3.6
$47 USD in 10 dias
(0 Comentários)
0.0
maripadma37

i am typist and i know English very well..i can do it for u..u can contact in WhatsApp +917904124578

$10 USD em 1 dia
(0 Comentários)
0.0
premginfotech

THanks for providing the project requirement in detail. I have 10+ years experience in developing e-commerce, wordpress , webportals etc., Gone through the excel sheet, i think we can provide u a small php application Mais

$150 USD in 7 dias
(0 Comentários)
0.0
aryankumar199816

Dear Sir I've carefully read your project details and understood what kind of service you want and I am totally qualified for this job. I can guarantee good service for you. You can Massage me and we can discuss more d Mais

$10 USD em 1 dia
(0 Comentários)
0.0
ij25a

I read the details and reviewed the Excel file My over 5 years' experience as a data analyst will adequately aid me to effectively handle your project. I use MS Excel for analysis and can create charts for visualizatio Mais

$50 USD em 1 dia
(0 Comentários)
0.0
sobujshirina

I want to get the job done. Relevant Skills and Experience Excel Exports

$47 USD in 10 dias
(0 Comentários)
0.0
$47 USD in 10 dias
(0 Comentários)
0.0
YEDP

I am very much available to complete this job. My time management & Project Knowledge are the keys to for any task to complete in time. Thanks

$43 USD in 7 dias
(0 Comentários)
0.0
ebrahimamin20

I read the details and reviewed the Excel file. I'm working in data entry and digitizing maps, i was entered data for all roads of Banha city in one week from google map and digitize it. i'm familiar with GIS Websites Mais

$10 USD in 7 dias
(0 Comentários)
0.0
jamshedahmedgtk

I have a lot of experience to makes statics data more easy and beautiful by adding graphics Relevant Skills and Experience good knowledge of Ms word, excel and know how to use SPS software

$47 USD in 10 dias
(0 Comentários)
0.0
emzee619

Hello I have read your details. I am willing to help you with this project. Waiting for you to hire me. Thanks

$70 USD in 5 dias
(0 Comentários)
0.0