[]
        
(Showing Draft Content)

Sparklines

GcExcel supports adding sparklines in template layout, which are visible in the Excel report generated after processing the template.

Follow the steps mentioned below to add a sparkline in template layout and configure its data to template cells:

You can also download the Excel template layout used in below example.

TemplateWorkWithSparkline[Template].xlsx

  1. Insert a sparkline in Excel's template layout by choosing Menu | Insert | Sparklines.

  2. In the "Create Sparklines" dialog box, choose a template cell as:

    • Data Range - Data to be displayed by sparkline

    • Location Range - Location where sparkline will be displayed

    Set data and location range of sparkline in template layout

After GcExcel processes the template layout, the Excel report will look like below:

Excel report output displaying sparklines

Note: In Excel report, the sparkline whose data range and location range are in the same column is displayed as a 'vertical' sparkline, otherwise, as 'horizontal' sparkline.