Create a readable chart from this data

$10-30 USD

Завершено

Опублікований

over 10 years ago

$10-30 USD

Оплачується при отриманні

I've attached a spreadsheet that is populated with new data every day on the Glenvc1, ColoVC, and MBUVC tabs. This spreadsheet monitors the overall capacity and usage of 3 separate systems. I would like a chart (or multiple charts) created on the first sheet that will help visualize the change in this data over time. Each tab is a separate environment, but data would be handled the same way in each. Here is a breakdown of the each part of the data and how it's relevant. Name - The name of the system (This will never change) TotalGB - The total capacity of the system (This will change once or twice a year, increasing) AllocGB - The total provisioned use. (This will change daily) PercUsed - AllocGB divided by TotalGB (This does not need to be charted as it will be visualized) Timestamp - The date the row was created I would like the data in the chart to be automatically updated as new records are added daily.

Data Entry

Data Processing

Excel

ID проекту: 5241257

Про проект

22 пропозицій(-ї)

Дистанційний проект

Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@priyal1997

Dear Sir ITS DONE please take the file from bellow link [login to view URL] if you are happy with the output, you can offer me the job Thanks Priyal

$25 USD за 1 день

5,0

(78 відгуки(-ів))

5,8

22 фрілансерів(-и) готові виконати цю роботу у середньому за $26 USD

@binaryromel

Hi there, I'm exert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$34 USD за 1 день

4,6

(65 відгуки(-ів))

5,5

@Midlander

As soon as you pay the fee into the site you can have a highly "interactive" graph showing your results that gives you significant flexibility using Sliders and Radio Buttons. Each time you open the graph: (1) You can change how MANY days you want to see, between one day and all the days: (2) You can set the "Start" and "End" dates between the first and latest date; (3) You can change the FREQUENCY of the data shown between daily, weekly, monthly, quarterly or annually. I made a sample based on your attachment,but I can't send it to you until you send me a Private Message first, because you made this a "restricted" project. I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl

$66 USD за 1 день

4,9

(6 відгуки(-ів))

4,0

@ajharul

Hello There, Thank you for this wonderful opportunity. After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I am confident; I can take up your project and do it with perfection. Let's discuss more about the project. Wishing to get your response. Best Regards Ajharul

$25 USD за 1 день

4,6

(6 відгуки(-ів))

2,6

@yes0

I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I ll complete your project with 100% accuracy. Pls review my feedback.

$15 USD за 0 день

5,0

(17 відгуки(-ів))

2,2

@vikas0903

A proposal has not yet been provided

$19 USD за 1 день

5,0

(2 відгуки(-ів))

2,1

@teeares

I am conversant with excel and have used the same to draw real time graphs. I can do this job for you qick and fast.

$15 USD за 2 дні(-в)

4,8

(3 відгуки(-ів))

2,1

@denisaelena

Hy sir! I'll be glad to be part of your team and do this job for you. i have 5 years experience in photoshop, dreamweaver, html, css, joomla, wordpress, excel, s.a. Your job is a simple one, I quarantee you 100% satisfaction...I'm a hard-worker person, perfectionist and meticulous. I'll do my job in time. I'm ready to strat anytime ... pm pls... HOPE TO HEAR YOU SOON WITH GOOD NEWS. GOOD LUCK

$25 USD за 1 день

4,8

(4 відгуки(-ів))

2,0

@shanondollar

simple and clear. I will be able to deliver in less than 10 hours. Thanks for your consideration. Looking forward to undertaking this project

$25 USD за 1 день

3,0

(1 відгук)

0,8

@sjprakas

A proposal has not yet been provided

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@VDreamz

Hi, we have read all the requirements and we are very confident to do this project from start till end. We definitely have some questions when we discuss project with you. We shall finish this project in a timely manner.

$30 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@imranalipml

A proposal has not yet been provided

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@mehreennoor

I hope i will do your work with my best effort and you will like it. I fully understand your job needs . I have done many projects in excel. i would like to have conversation with you to get the full knowlege about your requirement.

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@schungur

5 USD per Chart... IT'S CHEAP for EXPERIENCED DEVELOPER. CHECK MY BADGES AND PROJECTS, and ensure yourself that you will get a fast treatment

$20 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@venthini2602

A proposal has not yet been provided

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@idisblueflash

Hi, Astromgren I've made some demo chars, and I think I understand your needs. 1. I put the overall capacity and usage datas in one chart for each system. (three charts in one Sheet) 2. I used different types of chart to show your different datas. 3. I adjusted data's show range for a readable chart. 4. I added title and TotalGB data as the title of each chart. All works are done in Numbers with Mac Book Air, and it can be output into Excel format. If you have some questions, we can talk more in details.

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@ninrac

A proposal has not yet been provided

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@mkozlovskis

Hi, I have decent excel experience and am willing to do this job at a high quality in return for good feedback. Could you please confirm that it would be fine to have a separate chart for each column (with the corresponding date stamp)? I think it would make it more readable rather than if there were several lines (or bars) in merged charts. I've taken a look at the spreadsheet and it made some example charts. Please let me know if you'd like to take a look art them. They also get updated as new entries are added. Please let me know if you have any questions. Best regards, Martins

$20 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@hiqbal680

A proposal has not yet been provided

$25 USD за 2 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@ENRICOJ

I HAVE YOUR CHART READY ,DO NOT SETTLE FOR LESS!!!. CONTACT ME FOR A SAMPLE. WE CAN FINISH IT TODAY.!!! IM ONLINE NOW .

$23 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@naaziyaansari

I have worked as a Research and Financial Analyst and have a good knowledge of the same. I have also been handling PowerPoint presentations for the Clients as per their requirements and have worked as support to the Insolvency managers in UK in various aspects. If you hire me I will prove that I am the best in delivering my work more efficiently and accurately within the time span given. You can trust on me for any of your assignments and I will deliver the result in a prompt manner. I am looking forward to be outsourced by you.

$25 USD за 1 день