Excel Graph automation

$30-250 AUD

Completed

Posted

9 months ago

$30-250 AUD

Paid on delivery

Making an excel graph based on changing data. I Have attached the excel file I need help with (time graph [login to view URL]) I have attached a word doc we produce from the date in the spreadsheet (week end 0608) I have already made the spreadsheet but I need help with the Graph and getting it the correct size Each day we write in drink times each half an hour. We only currently are tracking 3 days (Thu, Sat & Sun) All days have different starting opening/closing times Thu 5pm-9pm Sat 10am-5pm Sun 11am - 5pm The date & data is entered on sheet "30 Minute Times" The graph is produced on sheet "Graph" We use the screenshot button to take a picture of the graph. I need the graph only to display the times for the day (see above Thu,Sat,Sun) as our problem is the graph bottom axis displays all the times that are not included. If we don't include them it still leaves it blank and squishes all the bar chart lines together. To Reiterate: -Enter sales times each half hour -Create graph based on data -Screenshot button needs to take a screenshot of a good full graph, not just squished in one side. -Times change each day (See above), so a Thursday graph should only have 5pm-9pm. But a Saturday would have 10am - 5pm -Graph shows green bars under 4 minutes and red bars for over 4 minutes. The word doc shows the graphs all squished to either the left or right and showing all the times instead of just the times relevant to the day.

Project ID: 37043400

About the project

46 proposals

Remote project

Active 9 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$30 AUD in 3 days

4.9

(594 reviews)

8.5

46 freelancers are bidding on average $115 AUD for this job

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra

$75 AUD in 3 days

4.8

(147 reviews)

6.2

@merinsinha

Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

$140 AUD in 2 days

4.8

(165 reviews)

5.8

@snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh

$140 AUD in 3 days

4.7

(49 reviews)

5.7

@BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 90+ projects on FL. Expertise in - • Macros • Formulae • VBA • User forms Pivot tables Willing to share a sample of my work done on various excel applications on this platform. Looking forward to hearing from you. Thank you Varun PS: Please have a look at the reviews given to me for excel on this platform. PPS: The price indicated in the bid is generic in nature. It may change basis on the scope of work post our discussion

$40 AUD in 7 days

4.8

(71 reviews)

5.5

@mutugijosepj1

Hi there, I can help you create an exceptional Excel graph. I am a research and data analyst with over seven years of excellent experience in Excel, data analysis, data entry, and data processing. Besides, I possess skills and abilities such as attention to detail, time management, and problem-solving. I have understood your project requirements and I assure you of excellent results adapted to your needs. As illustrated in my profile and past reviews, I deliver high-quality work within the budget and on time. Kindly inbox for more details. Thanks

$144 AUD in 2 days

5.0

(15 reviews)

4.9

@arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun

$140 AUD in 1 day

5.0

(24 reviews)

5.0

@faisal9263

Hi, I understand your requirements. You need an Excel graph that displays drink times data for specific days (Thu, Sat, Sun), with different opening and closing times. The graph should only show relevant times, avoid squishing, and use green/red bars for under/over 4 minutes. I'll help you achieve this by adjusting the graph settings, data selection, and formatting. By dynamically adjusting the data range and axis settings based on the day, you can ensure the graph displays only the relevant times and is not squished. Ensure to format the graph properly so that it's visually clear and captures the necessary information. Thanks

$140 AUD in 1 day

5.0

(16 reviews)

4.8

@EmiliaSimon

Hello, I can help you make your chart dynamic so that it displays the axis values for the actual hours only. I am an Excel Expert with extensive experience in creating charts and graphs, and I can quickly and easily deliver the results you need. Please feel free to contact me for any additional details. Thank you a lot. Best regards, Emilia

$55 AUD in 1 day

5.0

(26 reviews)

4.8

@mobimubasir

Hello. I read your requirement and also check attachment i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

$50 AUD in 1 day

5.0

(10 reviews)

3.6

@IMBASANTAKUMAR

I understand your project description and can confirm that I am the best fit for this job. With my extensive experience in data processing and Excel, I can ensure that your graph is made correctly with the correct size. I have worked on similar projects before and am confident that I can provide the required results within the given timeframe. My profile shows that I have skills in webscaping, Excel (advanced formula), VBA/Macro and option strategy of stock market which will be useful for this project. Additionally, I have experience in app development/website development as well as work flow management which will be beneficial for your needs. I understand that each day's starting opening/closing times may differ which is why I propose taking a screenshot of the graph at the end of each day so that it reflects the correct size for display purposes.

$30 AUD in 1 day

5.0

(35 reviews)

3.7

@saifulcmab

Hello, I can create a excel graph based on changing data. I am certified in advanced Excel, data analytics, and Dashboards from Macquarie University, Australia. I have a lot of experience in databases, data analysis, Excel Charts & Graphs. I am an Accountant and I have over 10+ years of experience in Accounting. My Skills In Excel : 1. Dashboard, Slicers for interactive dashboards. 2. Pivot Data, Pivot Table, Pivot Chart. 3. Macros, Conditional Format, Shape, Sparkline 4. Data Validation, Drop down list. Data Modelling 5. Power Pivot, VLOOKUP, XLOOKUP, Power Query, 6. Excel Function, DAX Function. 7. Analyzing data with Power Pivot. 8. Visualizing data with Power Pivot and Cube Functions. 9. Power BI, Creating a Power BI report. Regards,

$65 AUD in 1 day

4.6

(6 reviews)

2.9

@kavitadhingra

Hi, I understand you need help with making an excel graph based on changing data. I am a professional with 15 years of Industry experience in various technologies like Power BI, SQL Server, Excel ,VBA, SQL server, MS office, SSIS. I have worked on multiple Power BI projects with different data sources like SQL server, Oracle, Azure databricks. I have experience in Excel VBA and macros which will come in handy for this project. My skillset includes data processing which will be needed for entering sales times into the excel graph and getting it the correct size. Additionally my screenshot button can take a good full graph instead of squishing it in one side. I would love to discuss further how I can help you with this project. Please feel free to contact me if you have any questions or would like more information about me or my skillset.

$100 AUD in 4 days

5.0

(5 reviews)

2.6

@christinezekrian

Dear Sir, I trust this message finds you well. I'm excited about the prospect of collaborating with your team as a data collection expert. My proficiencies in Excel Functions, Excel itself, Web Scraping, Web Search, Power BI, Data Mining, Access, and DBMS make me confident in delivering precise results with a professional touch. Drawing from my strong Finance background and over 15 years of experience using Microsoft Excel for educational and analytical purposes, I am well-equipped to excel in this role. My expertise extends to Web Scraping and web research as well. I am enthusiastic about assisting you with automating Excel graph generation, utilizing data from the provided spreadsheet. Based on the detailed description you've shared, I am confident in my ability to create a dynamic and accurately-sized graph to meet your needs. Thank you for considering my application. I am eager to contribute to the enhancement of your Excel graph automation. Best regards, Christine

$70 AUD in 5 days

5.0

(1 review)

0.7

@anshchasha15456

Hi I'm interested in your project please send me a message so that we can discuss more about your project over chat. Thanks

$284.09 AUD in 2 days

0.0

(0 reviews)

0.0

@LemanSen

Im data entry specilaist. I do this work perfectyly. I am a housewife, I have 3 children. It is very important for me to get this job in order to support my household. You can be sure that I will do this job perfectly.

$100 AUD in 7 days

0.0

(0 reviews)

0.0

@nacerbelabbes85

Hey, Reading your requirements, with my skillet of programming with vba and data visualisation, I can automate your graph visualization problem. Let's talk for further details. Regards

$160 AUD in 2 days

0.0

(0 reviews)

0.0

@dipakmanadal906

Griaß di! Delighted to assist! Comprehending your requirement for precise Excel graphs capturing varied daily data, I'm eager to optimize the graph's size, ensuring accurate representation. My expertise in Excel, dynamic graphs, and effective communication ensures timely completion. Could we discuss specific design preferences or further requirements? I'll establish a clear schedule and ensure your satisfaction. Let's excel together! Kind regards, Dipak Mandal

$120 AUD in 4 days

0.0

(1 review)

0.0

@hamza957

Hello, my name is Hamza, and I am a Excel Graph Expert with over 2 years of experience in these fields. I understand your need for an excel graph automation and can help you make the required graph. Specifically, I am skilled in Excel Graph ….. THANKS NMAME hamza I

$30 AUD in 5 days

0.0

(0 reviews)

0.0

@sarkarraghav3

Full experience copy paste job i do this work honestly because i am in personel money problems i have have 5 experience in this job and I m freesher in freelancer

$140 AUD in 7 days

0.0

(0 reviews)

0.0

@Maxinto

Hi there, I can build you a dynamic Excel dashboard with excellent visualization and easy to use with the specific slizers to achieve your objectives. As an expert in Excel, I'm sure you'll like my graphs, having supported many clients in similar projects. Do you want to move forward? Please, send me a message to get started asap! Regards, Maxwell

$140 AUD in 2 days