Automatically creating and exporting graphs and tables from excel

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I want to automate the creation of a set of graphs. These graphs describe certain characteristics in a set of 200 cities I am studying. Each city has seven graphs, meaning 1400 or so graphs would be produced. What I am really seeking is a method for automating this process so the graphs can simply be sequentially and automatically created and exported as images to a set of folders. The data is organized in an excel spreadsheet.

The graphs themselves are sort of odd. I've attached an image, but the basic idea is that they are "rank order" graphs that show all of the values for the 200 cities, highlighting regional values and a specific city value. I can show you how to make these graphs manually, but you would have to figure out how to automate the process.

My timeline is tight - I'd like to have this finished and functioning in a week.

Excel Python R Programming Language

Project ID: #11298171

About the project

18 proposals Remote project Active 7 years ago

Awarded to:

someka

Hi there. We can write VBA code to automatically create charts from your data. We can finish this in 2-3 days. What I am planning to use some pivot tables and pivot charts integration with macro code for flexibility. I More

$550 USD in 3 days
(96 Reviews)
6.5

18 freelancers are bidding on average $427 for this job

cgullapalli

Hi, I am good at Excel and vba. I have gone through your description. Plz provide me the details further to work on. Looking forward to discuss in the chat.

$250 USD in 2 days
(213 Reviews)
6.6
gangabass

I can create a tool which will generate all graphs you need and save them as images just like you want. I can complete it in 2 days and all I need to start is your data and milestone payment from you. You'll release More

$315 USD in 2 days
(109 Reviews)
5.9
aminbros

A proposal has not yet been provided

$263 USD in 10 days
(10 Reviews)
4.5
kjgroup197318

-----------------------------Pro Python Developer! Best Result in Time!------------------------------ Dear, sir. Your project is very interesting to me, because I've really rich experience in python. So I'm very con More

$500 USD in 10 days
(15 Reviews)
4.9
kolosibalint

Dear Sir/Madam, I have 4 years of experience in Excel VBA programming. I work as a business data analyst Ford Motor Company creating automated reports and dashboards on car sales figures of 21 European countries. More

$250 USD in 5 days
(38 Reviews)
4.7
yogesh701

Hello there! If you could kindly share the data with me, i can program excel so that it will start producing automation results. Would be glad to render to you my professional service. Please check my profile for More

$415 USD in 10 days
(8 Reviews)
2.9
xhemalmuja

Hi Sir, I have read all your requirements and I can do this job very professionally and you will get Pro Quality Work Please Contact me or visit my portfolio in my profile. Thank you! :)

$250 USD in 0 days
(1 Review)
1.0
bellamystraat

Dear Sir, to solve your matter I suggest a simple program written in such a language as Java, C++, VB.net etc. If I understand your first specifications, the tool must be able to: - load your input data; - ask for More

$361 USD in 5 days
(1 Review)
0.7
hafizshoaib

Asalam o Alaikum, During my career, I have gained a wide knowledge and understanding of data collection methodologies, sampling methodologies, multivariate statistical analysis, Principles and techniques. I have out More

$277 USD in 10 days
(1 Review)
0.4
SrvTaxcon

I Have a expert knowledge I can performed better then anyone with best quality & less price. Please provide a opportunity

$555 USD in 10 days
(0 Reviews)
0.0
fjdiod

Hello! I can write a Python script using matplotlib module to automate this task. May you provide example of excel spreadsheet? Best regards

$250 USD in 3 days
(0 Reviews)
0.0
FixForce

As computer science students we know how to deal with tight deadlines and are sure we can automate your process within a week. We have quite some experience with text-processing languages such as Python and Bash that c More

$466 USD in 6 days
(0 Reviews)
0.0
wanguin

Hello my name is Irene. After reviewing the requirements of the job, I feel that I am a suitable match for this job. I am confident I can take up your project and do it to perfection. I am collage graduate with a Dipl More

$444 USD in 10 days
(0 Reviews)
0.0
shahriar52

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0
techsolutions3

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have me More

$555 USD in 10 days
(0 Reviews)
0.0
lihuangca

Hi, As a modeler and data scientist for over 10 years, I can offer you not only the good quality work in a timely basis, but also to feedback and tailor things to your needs. I am going to use R to automate the gene More

$555 USD in 6 days
(0 Reviews)
0.0
GabrielSoare

Hello, I am cloud engineer with 2 years experience in Azure / AWS / Profitbricks working full time for a german company specialized in BI. I am able to achieve your needs but we need to talk in detail your needs. Pleas More

$900 USD in 14 days
(0 Reviews)
0.0