I have been attempting to make box-and-whisker plots using Excel's QI Macros 2008, but at the end of the process I get an error message from Microsoft Visual Basic that says Run-time error (13): Type Mismatch. I've never used this part of Excel before, does anyone know where I may be going wrong, or how to fix this error? I am also getting #N/A For both my start and end values in the output.
I'll attach a sample workbook of what it gave me as an output.
Thanks!!
Last edited by VBA Noob; 12-28-2008 at 03:20 PM.
You book does not include any code. And whats is "Excel's QI Macros 2008"?
Have you seen this free utility?
http://peltiertech.com/Utility/BoxPlotUtility.html
I'm not completely sure what it is, but it seems to offer more ways to analyze data than Excel originally had - I got it off the Internet as a trial version...I didn't come across the peltiertech one, but it looks promising! I'm definately checking it out.
Thanks Andy!
ps...it worked like an absolute CHARM!!!
Your data seems to have 1943, 1953, and 1958 as headers.
The QI Macros consider numbers to be numbers, not headers.
I put an apostrophe in front ('1943, '1953, '1958) and it ran fine.
If you're using a trial version of the QI Macros, this should solve your problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks