Note: Images may be inserted into your messages by uploading a file attachment (see "Manage Attachments"). Even though it doesn't appear when previewed, the image will appear at the end of your message once it is posted.
Register Latest Topics

  Author   Comment  

Posts: 4
Reply with quote  #1 
Hi, i have recently finished reading "now you see it" and found it very helpful :) Im just wondering about strip plots in excel 2010.  I followed steve's instructions on p227 para 2 but dont seem to be able to get it working.  Has anyone had any success with this type of graph in excel?

Posts: 46
Reply with quote  #2 
Hi westcm -- see the screenshot below that shows how I managed to create the strip plot in excel 2007. I tried following Stephen's brief "instructions" on pg 227 (i.e. associate a single dataset with the x-axis), but the data did not plot correctly for me either. So, I ended up creating a Y data set equal to 1 for each x-axis data point. It's an extra step that feels a bit clunky, but it works.

(Afterwards, I played with formatting the chart to look similar to the example in the book.)


Attached Images
Name: Excel2007StripPlot.jpg, Views: 1127, Size: 154.43 KB


Posts: 4
Reply with quote  #3 
Hi Pete, thanks so much for ur advice - much appreciated. I gave it a go and it worked well. Thanks again :)


Posts: 803
Reply with quote  #4 
Hi Guys,

What I said in Now You See It about creating strip plots in Excel weren't meant to be step-by-step instructions. I always hesitate to provide instructions because changes in the software make them obsolete. The method that Pete described is exactly the method that I use.

Stephen Few
Previous Topic | Next Topic

Quick Navigation: