Column Chart in Word Processing Document
Column Chart in Microsoft Word Document
Creating a Column Chart
Practising the following steps, you can insert a Column Chart in MS Word 2013:
- Click in the document where you want to insert the chart, click the “Insert” tab, and then click “Chart” in the illustrations group to open the “Insert Chart” dialog box.
- Select “Column” in the sidebar, you will see a gallery of charts.
- Select the “100% Stacked Column” and press “OK” to insert the chart and Worksheet template to your document.
- Edit the Worksheet with your data to update the chart. See Chart Data (Excel).
- Save your Document.
Reporting Requirement
As a report developer, you are required to share orders quantity of the customers dynamically with the following key requirements:
- Report must show total Contract Prices by Quarters
- Report must be generated in the Word Processing Document.
Adding Syntax to be evaluated by GroupDocs.Assembly Engine
Chart Title
Total Contract Prices by Quarters<<foreach [in getContracts()
.where(c => c.getDate().getYear() + 1900 == 2015)
.groupBy(c => c.getManager())
.orderBy(g => g.key.getName())]>><<x [key.getName()]>>
Chart Data (Excel)
| 1st Quarter<<y [where(c => c.getDate().getMonth() >= 0 && c.getDate().getMonth() <= 2).sum(c => c.getPrice())]>> | 2nd Quarter<<y [where(c => c.getDate().getMonth() >= 3 && c.getDate().getMonth() <= 5).sum(c => c.getPrice())]>> | 3rd Quarter<<y [where(c => c.getDate().getMonth() >= 6 && c.getDate().getMonth() <= 8).sum(c => c.getPrice())]>> | 4th Quarter<<y [where(c => c.getDate().getMonth() >= 9 && c.getDate().getMonth() <= 11).sum(c => c.getPrice())]>> |
Category 1 | 4.3 | 2.4 | 2 | 3 |
Category 2 | 2.5 | 4.4 | 2 | 2 |
Category 3 | 3.5 | 1.8 | 3 | 5 |
Category 4 | 4.5 | 2.8 | 5 | 2 |
Please download the sample Chart with Filtering, Grouping, and Ordering document we created in this article:
Generating The Report
Column Chart in OpenOffice Document
To be investigated.