Skip to main content Skip to footer

SpreadJS Designer and Sparklines

The SpreadJS Designer allows you to create sparklines quickly and without code. The following sparkline types are available in the SpreadJS Designer.

  • Line
  • Column
  • Win/Loss
  • Pie
  • Area
  • Scatter
  • Spread
  • Stacked
  • BoxPlot
  • Cascade
  • Pareto
  • Bullet
  • Hbar
  • Vbar
  • Variance

To run the Spread Designer, double-click the SpreadJSDesigner.exe file in the designer folder. Use the following steps to create a Pie sparkline in the Designer.

  1. Add the data to the designer and any formatting.
  2. Select the sparkline type under the Insert tab. SpreadJSDesignSparkInsert
  3. Specify the location of the data you want to use in the sparkline. Then specify the location of the sparkline. SpreadJSDesignSpark1
  4. Expand the sparkline by merging the cells in column C. SpreadJSDesignSpark2
  5. The expanded sparkline appears as follows: SpreadJSDesignSparkMerged
  6. Use the Settings option to specify additional settings for the sparkline. SpreadJSDesignSparkSettings
  7. Specify settings such as color. SpreadJSDesignSparkColor
  8. You can select additional colors using the plus icon. SpreadJSDesignSparkSelect
  9. The finished Pie sparkline appears as follows: SpreadJSDesignSparkResult

MESCIUS inc.

comments powered by Disqus