asked on
Hello Experts,
I need some sample to read a table from a word file and generate a bar charts like below:
![Chart output]()
And the data that will be on a word file will be as like below:
![Chart Data on Word file]()
Is there any sample that will be help me in achieving this using Macro code. So that when ever the word file will be generated and someone opens it , the macro code will generate the chart and hide the entire table.
My Sample file will be as like the attached one.
SampleWordFile.odt
In the attached file the "Overall Risk Rating Trend" is the Dynamic chart that need to be generated using the table "Chart Data" at the end of the file.
Once the chart is generated the table should be hidden or removed.
Thanks,
Swadhin
I need some sample to read a table from a word file and generate a bar charts like below:
And the data that will be on a word file will be as like below:
Is there any sample that will be help me in achieving this using Macro code. So that when ever the word file will be generated and someone opens it , the macro code will generate the chart and hide the entire table.
My Sample file will be as like the attached one.
SampleWordFile.odt
In the attached file the "Overall Risk Rating Trend" is the Dynamic chart that need to be generated using the table "Chart Data" at the end of the file.
Once the chart is generated the table should be hidden or removed.
Thanks,
Swadhin
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.