1. GroupDocs Documentation
    2. /
    3. GroupDocs.Assembly Product Family
    4. /
    5. GroupDocs.Assembly for Java
    6. /
    7. Developer Guide
    8. /
    9. Advanced Usage
    10. /
    11. Working with Chart Reports - Scatter
    12. /
    13. Scatter Chart in Presentation Document

    Scatter Chart in Presentation Document

    Note
    In this article, we will use GroupDocs.Assembly to generate a Scatter Chart report in Presentation Document format.
    Note
    The code uses some of the objects defined in The Business Layer.

    Scatter Chart in Microsoft PowerPoint Document

    Creating a Scatter Chart

    Please following below steps to create Scatter Chart in MS PowerPoint 2013:

    1. 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.
    2. Select “XY (Scatter)”.
    3. Preview “Scatter” and press OK to insert the chart and Worksheet template to your document.
    4. Edit the Worksheet with your data to update the chart. See Chart Data (Excel).
    5. 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 show information on a Scatter Chart.
    • It must indicate total contract prices by month.
    • Report must be generated in the Presentation Document.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

    Chart Title 

    Total Contract Prices by Months<<foreach [in getContracts()
.groupBy(c => c.getDate().getMonth())]>>

    Chart Data (Excel)

    X-ValuesTotal Contract Price«x [key + 1]»«y [sum(c => c.getPrice())]»
    0.72.7
    1.83.2
    2.60.8

    Download Scatter Chart Template

    Please download the sample Scatter Chart document we created in this article:

    Generating The Report

    Scatter Chart in OpenOffice Presentation Document

    To be investigated.

    © Groupdocs 2001-2024. All Rights Reserved.