Macro to create Bar charts

Hello Experts,

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

Microsoft OfficeVB Script

Last Comment

Swadhin Ray

8/22/2022 - Mon

Randy Downs

9/20/2016

There are some pretty good samples here

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

9/23/2016

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.

ASKER CERTIFIED SOLUTION

Randy Downs

9/23/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial