Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
My CFO wants to add a pie graph to the bottom of a Word document taken from information in an Excel spread sheet. It is a letter to employees with an explanation of benefit costs. This information will be pulled from actual employee records imported to Excel. Automating the process would save tyoing the info near 500 times. It has been suggested that using mail merge to pull employee information to automate printing of the letters. Keeping in mind they want the pie graph updated with individual records. Is this possible?
2 replies
by robertsclyde Accepted solution
Clarifications
by rtunnell Accepted solution
Merging into MS graph is not easy. But, another solution I just posted is how we used to build these applications before acquiring some specialized software. Simply create the benefit statement on a seperate worksheet of the same Excel file. Then create a third worksheet to hold one row of data from your data file. Then, link the charts of the statement to the data cells on this 3rd sheet. Write a VBA routine to recurse the data sheet copying one row of data to the 3rd sheet, then execute a print command. 949-253-7502 if you have questions.
Ray
This discussion is closed to new replies.
Trending Peripheral posts
Sort by Trending
0 helpful
4 replies
Question Locked
I need to know what port-type this is (What the plug is called)
0 helpful
3 replies
Question Locked
Are ink printers worth it in 2025, or are there better options?
0 helpful
4 replies
Question Locked
My PS5 controller wont connect to my desktop help?
0 helpful
8 replies
Question Locked
Fusion5 charging
0 helpful
2 replies