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.
11 freelancers are bidding on average $17/hour for this job
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