Covers:
- Adding a chart that references data markers
- Optional - data marker as the chart title
Table of Contents | ||
---|---|---|
|
Intro
Info |
---|
This is Part 2 3 of a 3-part tutorial series for the Simple Expense Summary scenario. It is recommended that you complete Part 1 - Getting Started and Part 2 - Working with Formulas before starting this section. |
Info |
---|
The sample code template (part2part3_template.xlsx), page (Part2Part3.aspx), and code behind (Part2Part3.aspx.cs) are included in the SimpleExpenseSummary project available for download as part of the ExcelWriter Basics Tutorials. |
This part focuses on adding some Excel formulas to the template file from Part 1. Specifically, this covers combining data marker values with other text, adding a 'Total' row after imported data, and including formulas in imported data rows. Since the formulas are native Excel functionality, we adding and formatting a pie chart in the template file. We will only be modifying the template file. There are no changes to the code from Part 12.
Adding a Chart
Final Code
...