Monday, November 27, 2017

What are the differences for Sparklines in Microsoft Excel and in R?

These are the sparkline related functions in R:
newSparkLine()
newSparkBar()
newSparkBox()
newSparkHist()
newSparkTable()

You could get access to sparkLines in R using the package "sparkTable"
You may need to get the Package from a CRAN Site.

These functions are used with plot(). If the method export() is used then they are saved as mini-plots in png,eps and pdf.

The Spark lines in MS Excel are:


SparkLine_00

SparkLine_01

Excel Sparklines

It is straightforward to use in Excel as long as you have the data as in the posts.
http://hodentekhelp.blogspot.com/2017/06/how-do-you-create-sparklines-in-excel.html
http://hodentekhelp.blogspot.com/2017/06/how-does-winloss-sparkline-work.html

Examples (graphic) of Sparkline(), Sparkbar() and


R Reference for SparkTable()
https://cran.r-project.org/web/packages/sparkTable/sparkTable.pdf
R has a larger option with sparklines than Microsoft Excel.

No comments: