Scatter Chart in Email Document
In this article, we will use GroupDocs.Assembly to generate a Scatter Chart report in Email Document format.
Scatter Chart in Email Document
This feature is supported by version 17.8.0 or greater
Creating a Scatter Chart
Please following below steps to create Scatter Chart in MS Outlook 2013:
- Create a new Email.
- Click in the email 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 “XY (Scatter)".
- Preview “Scatter” and press OK to insert the chart and Worksheet template to your email.
- Edit the Worksheet with your data to update the chart.
- Save the template.
Reporting Requirement
As a report developer, you are required to show contract prices by month with the following key requirements:
- Report must be in .eml or .msg format.
- It must add email recipient, css and subject of the email.
- Report must show information on a Scatter Chart.
- It must indicate Price of each order by month.
Adding Syntax to be evaluated by GroupDocs.Assembly Engine
Chart Title
Total Order Prices by Months<<foreach [in orders
.GroupBy(c => c.OrderDate.Month)]>>
Chart Data (Excel)
X-Values | Total Order Price<<x [Key]>><<y [Sum(c => c.Price)]>> |
0.7 | 2.7 |
1.8 | 3.2 |
2.6 | 0.8 |
For detailed technical information about syntax,expressions and report generation by the engine, please visit: Working with GroupDocs.Assembly Engine.
Download Scatter Chart Template
Please download the sample Scatter Chart document we created in this article:
Generating The Report
The code uses some of the objects defined in: The Business Layer