We want to automate the production of a 4 to 7 page document with charts, graphs, some text boxes, some picture import and some copy from drop down menus. Our assumption is that the document can be developed as an Excel document with the data imported or entered into sheets 2, 3 and 4 combined with drag and drop copy, pictures or PDF's into text boxes.
Currently, we are manually producing the document in Word.
Page 1 has: 1) some copy in a text box, 2) a head-shot imported from Linked-In in a text box, 3) a horizontal bar chart with 54 data points from an Excel data entry sheet, 4) a single column bubble chart, 5) an x-y bell curve chart and 6) a score 8/10.0 from a second Excel data input sheet.
Page 2 has a large text box where we manually paste a pdf from an on-line source.
Page 3 has a table at the top with: 6) enter 5 descriptive words in row 1, 7) enter 4 characteristics in row 2 (could be drop down choices), 8) short text in row 3 and a number % from the second Excel sheet.
The bottom half of the page 3 has: 9) 5 single horizontal bars with 2 data points on each and 10) a short text box (drop down) under each . . . .