Example files are available to registered members only... Register and login !

Author Topic: Support needed: BOXPLOT - use as price chart (see example)  (Read 1029 times)

Offline koolkidkris

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
  • SfE user
Support needed: BOXPLOT - use as price chart (see example)
« on: January 13, 2015, 01:27:01 PM »
Hi,


I am big fan of sparklines and I´m trying to use the boxplot sparklines in a way like shown in the example: showing a (calibrated across cells) span of values, indicating MIN, MAX and two to be defined values (e.g.: average and own value). This is supposed to be used in customer satisfaction surveys.


Any help on this? As you can read, I´m not an Excel expert and I cannot figure out myself how to use it in this way... :D
koolkidkris

Offline Fabrice

  • Moderator
  • Administrator
  • Sr. Member
  • *****
  • Posts: 135
  • Karma: +18/-0
  • Creator of Sparklines for Excel
    • Sparklines for Excel
Re: Support needed: BOXPLOT - use as price chart (see example)
« Reply #1 on: January 17, 2015, 10:15:40 AM »
Hi,
Your request was in fact my first version of BoxPlot, using values calculated separately from the Boxplot function.
Let me find it in my archive an post it on the forum.
However, I this will be a separate UDF, not embeded in SfE....
It will work just the same  8)
I keep you posted.
Fabrice Rimlinger - Creator of Sparklines for Excel
MacBook Pro Retina
Office 2011 for Mac
Virtual machine : Windows 7 - Office 2013 x32