Tag Archives: R and Excel

Don’t Try This With Excel

In this post I show 4 charts of the same data to demonstrate  what Excel chart users are missing by not having a more powerful charting tool. This post,  building on my previous discussion of using factors for conditional formatting,  shows the potential advantages of plotting summary values and bounding area polygons . These analytical displays are not readily available to even advanced Excel users. Continue reading

Learn R Toolkit Videos (Updated 6/14/14)

My list of free Learn R Toolkit videos is growing. Here’s the latest list of free videos:

  • Get Familiar with R
  • Download & Install R
  • Configure Working Directory – Set Start-in Folder
  • Example R Session
  • Getting R Help
  • R Packages
  • Compare R and Excel Worlds
  • Missing Data – R and Excel

So there’s no reason for you to put off learning R. You now have a risk free way to start using R  for your advanced charts.

Excel’s Missing Factor

In this post I show how R’s factor data type allows users to produce effective charts much more quickly and simply than Excel. Since Excel does not include a “factor” data type, users need to use tricks and workarounds to categorize and display factor type data.

Excel Example Data Set

In  his “VBA to Split Data Range into Multiple Chart Series”  (May, 2008) , Jon Peltier writes:

A common problem is to make a chart from a list like this one. You want separate series for each item in one column (e.g., the cities in the first column), but your list is different every time, and you have to spend an hour assigning data to each series in the chart.

This is a job for VBA. It’s possible to write a simple loop that reads the first column of the range, grouping rows together by item.”

Continue reading

Learn R Toolkit (Updated 6/14/14)

Learn R Toolkit: I have developed this toolkit to help Excel users quickly learn R so that you can make those advanced charts that you really want to make. I use over 100 PowerPoint slides, 19 videos 40 R scripts, 12 data files and 3 Excel workbooks to lead you up the R learning curve as quickly and comfortably as possible.

As an Excel user, I explain essential R concepts using Excel examples and terminology so that you can learn R fundamentals using your Excel knowledge. The videos demonstrate the R scripts and then you use the same R scripts in a series of assignments. The R scripts are fully commented and organized for reuse so that you can use them as starter scripts for you real world projects. Finally, the PowerPoint slides can be printed out to give you a valuable memory jogger resource. This toolkit will save you many hours learning R.

Visit my web page to get more information about Learn R Toolkit.

Video To Help Excel Users Get Familiar With R

I’ve made a short (9 minute) video to help Excel users get familiar with R.  This video gives a quick overview of the R user interface, demonstrates an R session and walks through a short R chart script. This video is for those Excel users who have heard about R and would like to get a better feel for how it works and what its like.

Here’s  a link to my Getting Familiar video.

Let me know what you think.

Step Charts: R is Easier Than Excel

In this post, I show how to make a Step Chart with R.  The chart also includes a lowess smoother and annotation.  Readers can visit my ProcessTrends.com site to see how to make a step chart in Excel. Continue reading

Using R to Enhance an Excel Chart

In this post I show how to add a loess fit from R to an Excel chart. Continue reading