Showing posts with label SparkTable(). Show all posts
Showing posts with label SparkTable(). Show all posts

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.