Closed

[url removed, login to view] & Excel - Charts & Graphs Macro

We have 3 different graphic reports (one or two pages each) in [url removed, login to view] We need to find a way to automate the input, conversion and output of the reports by developing a macro or some other production process.

Example - The first is a one page report with a Pie Chart (5 constant small slices, about 20% and one major slice 80% of the pie) and a table (7 rows with constant titles and 7 columns for weekly data). Each week the shading of the large slice changes starting at 20% and moving up to 85% coverage of the major slice over 7 weeks. Each week we add data to the next column of the table from a computer report. The data can be input manually or through an API. We would like to automate this process in some manner rather than doing individual edits to the chart and table each week. The solution could be a software or shareware or a macro of some sort or other.

Example #2 - We have a one page report that is a table. The numbers and titles on the left axis range from 3.1 to 6.9 but for each version of the chart, we only use a section of the chart (maybe 3.3 to 4.8 or section 4.7 to 6.1) The five column titles across the bottom stay constant. We plot 5 to 7 points on each table (row 4.7 / column 3.9) and then add a person's name and 4 points of information data (John Smith $240K + Car Allow, MBA Harvard'89, 9.2, 86%) One or two of data dots may change colour and the last two information data will be a different colour than the name, $xx and school info.

Skills: Excel, Microsoft, Word

See more: excel macro charts, need to find a word, harvard solution, harvard data, graphs on computer, graphs of data, graphs in c, excel macro to word, example of graphs, computer graphs, car section 2, a graphs, about graphs, word input, sort excel, reports in excel, graphs, five to word, excel reports, excel charts, excel automate, excel $2-30, docx, data plot, moving car

About the Employer:
( 0 reviews ) Canada

Project ID: #2527892

11 freelancers are bidding on average $17/hour for this job

FIBIN

Hi, I am an expert in excel and VBA Programming in Excel. I am interested to work for your project .I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac More

$15 CAD / hour
(37 Reviews)
5.1
Nhcuong

Hi, I can do it! I'm programmer for years and very familiar with VBA for MS Office automation. What you need can be automated with vba from with either word or excel. What is your offcie version? Please send your curr More

$15 CAD / hour
(21 Reviews)
4.8
selopezr

Hi there, I'll be glad to collaborate!

$15 CAD / hour
(14 Reviews)
4.1
jadinv

Hello, This sounds like an interesting project. I think that I can efficiently provide a robust and easy-to-use solution for you. I will send you a private message with some more information. Jeff

$35 CAD / hour
(3 Reviews)
4.0
SmartGuru

Hi, Excel vba expert here. Will be be glad to take up this project. Can you please share sample files for further analysis. Thanks!

$15 CAD / hour
(6 Reviews)
3.5
adim

Hello there, I'm a software engineer with more than 10 years experience in Excel, Access, VBA, VB6 and .NET. I'm sure I can help you with your task. I'm waiting for detailed project description. Best regards, A More

$15 CAD / hour
(6 Reviews)
3.4
AccuPro

Hello, I should be able to achieve this.

$15 CAD / hour
(2 Reviews)
1.8
netchampion

Hi there, I could give you a windows application written in .net framework and it will generate the excel spreadsheets with required inputs. As I have some components ready that generates the excel sheet with .net fra More

$15 CAD / hour
(0 Reviews)
0.0
hacking9

Best offer is waiting for in pm check your pm or best offer

$15 CAD / hour
(0 Reviews)
0.0
atteequrrehman55

these are basic things i am master in using microsoft office. you will see this in my [url removed, login to view] bless you

$17 CAD / hour
(0 Reviews)
0.0
yogendrajain07

Hi, I completely understand your project requirements and have worked on similar projects. My earlier experience, will enable me to complete the project in short time. I have very rich Excel and VBA experience and More

$15 CAD / hour
(0 Reviews)
0.0