Scatter Chart in Spreadsheet Document
Leave feedback
NoteIn this article, we will use GroupDocs.Assembly to generate a Scatter Chart report in Spreadsheet Document format based on the use case: Working with a Business Case.
NoteThe code uses some of the objects defined in The Business Layer.
Please follow below steps to create Scatter Chart in MS Excel 2013:
- Add a new Workbook.
- Click in the workbook where you want to insert the chart, click the “Insert” tab, and then click “Insert Scatter Chart Icon” in the charts group.
- A drop-down with charts will appear, select the “Scatter” and press “OK” to insert the chart.
- Click on the chart you just inserted, then click the “Change Data” icon in Data group.
- Now add legend entries. See Chart Data.
- Save your Document.
As a report developer, you are required to show your customers’ orders prices by month with the following key requirements:
- Report must show information on a Scatter Chart.
- It must indicate Price of each order by month.
- Report must be generated in the Spreadsheet Document.
Total Order Prices by Months<<foreach [in orders
.GroupBy(c => c.OrderDate.Month)]>>
Legend Entries
="Total Order Price<<x [Key]>><<y [Sum(c => c.Price)]>>"
TipFor detailed technical information about syntax, expressions and report generation by the engine, please visit: Working with GroupDocs.Assembly Engine.
Please download the sample Scatter Chart document we created in this article:
- Scatter Chart.xlsx (Template for CustomObject and JSON examples)
- Scatter Chart_DB.xlsx (Template for DataSet, DataBase and XML examples)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-.NET | |
//Setting up source spreadsheet template | |
const String strSpreadsheetTemplate = "Spreadsheet Templates/Scatter Chart.xlsx"; | |
//Setting up destination document report | |
const String strSpreadsheetReport = "Spreadsheet Reports/Scatter Chart Report.xlsx"; | |
try | |
{ | |
//Instantiate DocumentAssembler class | |
DocumentAssembler assembler = new DocumentAssembler(); | |
//Call AssembleDocument to generate Scatter Chart Report in spreadsheet format | |
assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strSpreadsheetTemplate), | |
CommonUtilities.SetDestinationDocument(strSpreadsheetReport), | |
new DataSourceInfo(DataLayer.GetOrdersData(), "orders")); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-.NET | |
//Setting up source spreadsheet template | |
const String strSpreadsheetTemplate = "Spreadsheet Templates/Scatter Chart_DB.xlsx"; | |
//Setting up destination document report | |
const String strSpreadsheetReport = "Spreadsheet Reports/Scatter Chart_DB Report.xlsx"; | |
try | |
{ | |
//Instantiate DocumentAssembler class | |
DocumentAssembler assembler = new DocumentAssembler(); | |
//Call AssembleDocument to generate Scatter Chart Report in spreadsheet format | |
assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strSpreadsheetTemplate), | |
CommonUtilities.SetDestinationDocument(strSpreadsheetReport), | |
new DataSourceInfo(DataLayer.GetOrdersDataDB(), "orders")); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-.NET | |
//Setting up source spreadsheet template | |
const String strSpreadsheetTemplate = "Spreadsheet Templates/Scatter Chart_DB.xlsx"; | |
//Setting up destination document report | |
const String strSpreadsheetReport = "Spreadsheet Reports/Scatter Chart_DT Report.xlsx"; | |
try | |
{ | |
//Instantiate DocumentAssembler class | |
DocumentAssembler assembler = new DocumentAssembler(); | |
//Call AssembleDocument to generate Scatter Chart Report in spreadsheet format | |
assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strSpreadsheetTemplate), | |
CommonUtilities.SetDestinationDocument(strSpreadsheetReport), | |
new DataSourceInfo(DataLayer.GetCustomersAndOrdersDataDT())); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-.NET | |
//Setting up source spreadsheet template | |
const String strSpreadsheetTemplate = "Spreadsheet Templates/Scatter Chart_DB.xlsx"; | |
//Setting up destination document report | |
const String strSpreadsheetReport = "Spreadsheet Reports/Scatter Chart_XML Report.xlsx"; | |
try | |
{ | |
//Instantiate DocumentAssembler class | |
DocumentAssembler assembler = new DocumentAssembler(); | |
//Call AssembleDocument to generate Scatter Chart Report in spreadsheet format | |
assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strSpreadsheetTemplate), | |
CommonUtilities.SetDestinationDocument(strSpreadsheetReport), | |
new DataSourceInfo(DataLayer.GetAllDataFromXML(), "ds")); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-.NET | |
//setting up source | |
const String strDocumentTemplate = "Spreadsheet Templates/Scatter Chart.xlsx"; | |
//Setting up destination | |
const String strDocumentReport = "Spreadsheet Reports/Scatter Chart_Json Report.xlsx"; | |
try | |
{ | |
//Instantiate DocumentAssembler class | |
DocumentAssembler assembler = new DocumentAssembler();//initialize object of DocumentAssembler class | |
//Call AssembleDocument to generate Scatter Chart report in spreadsheet format | |
assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strDocumentTemplate), | |
CommonUtilities.SetDestinationDocument(strDocumentReport), | |
new DataSourceInfo(DataLayer.GetCustomerOrderDataFromJson(), "orders")); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |
To be investigated.
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.