Hi All,

Just wondering if anyone can help me with an issue that I have.

I have created an Excel Spreadsheet with a system of creating a Word Document via Mail Merge in VBA.

The spreadsheet allows the user to input numerical data and the formulas calculate the equations to be used within the Mail Merge to ensure that each person is being sent correct personalised data.

The information that is displayed regards the person's BMI Centile.

I have been asked to change the letter to include a sectional bar chart that would plot the person's BMI.

The sections would be as follows.

<2
2 - 90
91 - 97
>98


I would then need a plot on the correct section of what the person's BMI is.

However I am unsure of how to include this in the letter, or how to create the correct chart in Excel.

Please let me know if you need any more info.