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.
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.
This article contains two samples: a basic chart in Word (WordChart.docm), and a pair of files (ExcelWithChart.xlsm and WordChartLinkedToExcel.docm) that show how to have an interactive Word document that uses a chart created in Excel. You can download the code samples from the MSDN Code Gallery.
Swadhin Ray
ASKER
Say for example I build a html table in a word file with the chart data , and can we read the data from the table and build an chart dynamically.